Write / overwrite a sheet in an existing excel workbook (without overwriting entire workbook)?

[mikedolanfliss]

Hi there - Exciting package!

Is it possible to write a new (named) worksheet into an existing excel workbook? This would be either inserting a new sheet OR overwriting an existing sheet's contents without dumping the rest of the workbook's sheets. I see that multiple sheets can be written out at once with a named list argument, but it seems valuable to be able to insert new information into existing workbooks while preserving some of what's there. May have missed it, but skimmed help and hunted online, couldn't find how to do that in writexl. I think this would be (.... append = ) equivalent in one of the other excel-writing R packages.

[cyrusmsk]

Hi @mikedolanfliss IIUC this R package based on C library libxlsxwriter, and this C library can't editing workbooks, only creating new one. http://libxlsxwriter.github.io/introduction.html - it is written here

[mikedolanfliss]

That's helpful information I wasn't aware of, thanks. That's a big limitation for my use cases.