I am using openxlsx2 to create an excel document and scale the content to one page for printing. However the font size of the footer is not scaled as well. In Excel there is an option called Scale with document to achieve this, but I haven’t found an parameter for this in openxslx2. Is there a way to “insert” that property into wb?

I’m building a workbook for my colleagues containing all the tables they need for our Sector report. I want to add a table which is grouped by a factor.

I would like to write tables to sheets in case there are no data yet and to continue the Rscript in case that there is already data in the sheet.