I have an xlsx workbook on my desktop with existing sheets. Some of the sheets includes charts (e.g. line chart). I have a dataframe in R that I would like to write into a sheet in this workbook and then save the workbook. I am using loadworkbook to bring in the file and then writing the data to the correct sheet. After doing this, when I open the workbook, the data writes in correctly, but the sheets with the charts are now blank (the charts aren't preserved). Is there a way to keep them? When I click on the sheets formerly with charts, they are now blank.
I'm using loadworkbook from the openxlsx package