R - Extracting worksheet style and copying into a different workbook

358 Views Asked by At

I would like to copy the entire sheet (retaining the style) from one workbook into another workbook.

I tried cloneSheet() from the XLConnect package but I'm not sure if it can be used to clone a worksheet to a different workbook.

I also tried createSheet() to create a new sheet in workbook_1.xlsx then, readWorksheet() in workbook_2.xlsx, and finally writeWorksheet() to write the data from workbook_2 to workbook_1, but only the data gets transferred and not the style.

Thanks in advance for any inputs.

0

There are 0 best solutions below