Re: [R] Output multiple sheets to Excel files with openxlsx::write.xlsx

2020-05-27 Thread Jeff Newmiller
give the function a list of data frames. On May 26, 2020 11:21:58 PM PDT, John 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

Re: [R] Output multiple sheets to Excel files with openxlsx::write.xlsx

2020-05-27 Thread Ivan Calandra
Hi, Rather than creating a workbook as suggested by Enrico, you can simply supply a list to write.xlsx(); each element will be saved in a separate sheet: write.xlsx(list(a = df1, b = df2), file = fl_out) That is not really appending, but that might work for you. HTH, Ivan -- Dr. Ivan Calandra T

Re: [R] Output multiple sheets to Excel files with openxlsx::write.xlsx

2020-05-27 Thread Enrico Schumann
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 w

[R] Output multiple sheets to Excel files with openxlsx::write.xlsx

2020-05-26 Thread John
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/pa