On Wed, 27 May 2020, John writes:
> Hi,
>
> This is my code a few years ago. I was able to output multiple sheet to
> an excel file. Nevertheless, the "append" argument appears to be obsolete.
> Now I see only one sheet, the latest added sheet, in the output. Is there
> any other way to do it with openxlsx::write.xlsx or other
> functions/packages?
>
>
> openxlsx::write.xlsx(df1, file=fl_out, sheetName="a",
> col.names=TRUE, row.names=FALSE, append=TRUE, showNA=FALSE)
>
> openxlsx::write.xlsx(df2, file=fl_out, sheetName="b",
> col.names=TRUE, row.names=FALSE,
> append=TRUE, showNA=FALSE)
>
> Thanks!!
>
I think you need to create a workbook first, then add
the sheets, and finally write the workbook to a file.
Something like this:
df <- data.frame(a = 1:3,
b = 4:6)
library("openxlsx")
wb <- createWorkbook()
sheet <- "sheet1"
addWorksheet(wb, sheet)
writeData(wb, sheet = sheet, x = df)
sheet <- "sheet2"
addWorksheet(wb, sheet)
writeData(wb, sheet = sheet, x = df + 1)
saveWorkbook(wb, file = "~/Desktop/two_sheets.xlsx")
--
Enrico Schumann
Lucerne, Switzerland
http://enricoschumann.net
______________________________________________
[email protected] mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
