将数据帧追加到 R 中现有 Excel 文件的新工作表

Question

我有一个excel文件data.xlsx，它有两张Sheet1和Sheet2，现在我想将df1和df2从R附加到data.xlsx中，名称为Sheet3和Sheet4，我已经尝试过：

library(xlsx)
write.xlsx(df1, "data.xlsx", sheetName = "Sheet3", row.names = FALSE)
write.xlsx(df2, "data.xlsx", sheetName = "Sheet4", row.names = FALSE)

但是它覆盖了原始文件的Sheet1和Sheet2，我们如何解决这个问题？

谢谢。

Answer 1

包xlsx允许您执行此操作。

http://www.sthda.com/english/wiki/r-xlsx-package-a-quick-start-guide-to-manipulate-excel-files-in-r#add-a-table-in-to-worksheet

Answer 2

此解决方案可能有效：

library(xlsx)
# Write the first dataset df1 in a workbook
write.xlsx(df1, file = 'data.xlsx', sheetName = 'Sheet3, append = TRUE)
# Add a second dataset df2 in a new worksheet
write.xlsx(df2, file = 'data.xlsx', sheetName = 'Sheet4', append = TRUE)