如何使用 R 将多个数据框导出到同一个 xlsx 文件? [英] How to export multiple data frames to same xlsx file with R?

问题描述

有人可以帮助我如何将多个数据框导出到 R 中的同一个 xlsx 文件吗?

Can somebody help me on how to export multiple data frames to the same xlsx-file in R?

我知道如何做 excel，但在导出几个文件后出现内存不足错误.所以我不想碰excel.

I know how to do it excel, but getting an out of memory error after exporting few files. So I do not want to touch excel.

推荐答案

write.table(df1, "test.csv", row.names = F)
write.table(df2, "test.csv", append = T, col.names = F, row.names = F)

在一个 xlsx 文件中写入两个不同的工作表:

To write to two different sheets in an xlsx-file:

library(openxlsx)
wb <- createWorkbook()
addWorksheet(wb, "Sheet 1")
addWorksheet(wb, "Sheet 2")
writeData(wb, 1, df1)
writeData(wb, 2, df2)
saveWorkbook(wb, file = "test.xlsx", overwrite = TRUE)

这篇关于如何使用 R 将多个数据框导出到同一个 xlsx 文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！