'saving multiple tables in xlsx files
do we have any functionality or function which can paste multiple tables in single sheet of xlsx files.
lets say i have n number of tables and all tables have different size and format. now i want to save all the tables in xlsx file in one single sheet. with a specific space between them.
library(openxlsx)
library(fs)
library(writexl)
#l <- list(IRIS = iris, MTCARS = mtcars)
#write.xlsx(l, file = "writeXLSX2.xlsx")
#write.xlsx(l, file = "writeXLSXTable2.xlsx", asTable = TRUE)
My output is like the output of many tables
t1 = mtcars
t2 = mtcars[,1:5]
t3= IRIS
t4 = IRIS[1:8,]
at last it should create a list of all the tables above and then paste in xlsx file with specific space.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|