write_xlsx - just add sheets, do not overwrite file

I'd like to write_xlsx some data to excel sheets in an existing workbook. However, instead of adding sheets, write_xlsx overwrites the entire excel workbook with the new sheet(s). I used to be able to say append = TRUE, but that option seems to have vanished. Is there a way to simply append a few new sheets to an existing notebook?

write_xlsx(mydata, "mydata.xlsx")

Upon further examination, I used to use write.xlsx, not write_xlsx.

write.xlsx is a different function altogether with many more options for customizing the output. Punctuation matters!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.