Writing R dataframes to excel files with multiple worksheets

Question

I am currently using write_excel_csv2 from readxl to write a data.frame in R to an excel file. How can I write two data.frames to two worksheets within the same excel file? To give an example, how can I combine the following two files to one?

write_excel_csv2(mtcars[1:10,], file_name1)
write_excel_csv2(mtcars[11:20,], file_name2)

MarBlo · Accepted Answer · 2021-01-04 12:32:27Z

5

You can write each DF to the same xlsx.file and specify different names for the worksheets. You have to use append = TRUE for the second worksheet.

library(xlsx)
write.xlsx(mtcars[1:10,], file="filename.xlsx", sheetName="sheet1", row.names=FALSE)
write.xlsx(mtcars[11:20,], file="filename.xlsx", sheetName="sheet2", append=TRUE, row.names=FALSE)

This solution comes from here

answered Jan 4, 2021 at 12:32

MarBlo

4,5441 gold badge18 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

stefan · Accepted Answer · 2021-01-04 12:24:14Z

4

write_excel_csv2 just exports your data as a csv. If you want to export to excel have a look at writexl or openxlsx or ... packages, e.g. using writexl::write_xlsx you could do:

writexl::write_xlsx(list(sheet1 = mtcars[1:10, ], sheet2 = mtcars[11:20, ]), "mtcars.xlsx")

answered Jan 4, 2021 at 12:24

stefan

130k6 gold badges42 silver badges84 bronze badges

Collectives™ on Stack Overflow

Writing R dataframes to excel files with multiple worksheets

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related