give the function a list of data frames. On May 26, 2020 11:21:58 PM PDT, John <miao...@gmail.com> wrote: >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!! > > [[alternative HTML version deleted]] > >______________________________________________ >R-help@r-project.org 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.
-- Sent from my phone. Please excuse my brevity. ______________________________________________ R-help@r-project.org 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.
