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.
tried this way but its creating multiple sheets rather than single sheet.