search

miraisolutions / xlconnect

XLConnect: Excel Connector for R
129 stars 32 forks source link

Clone across excel files #113

Open JacobBas opened 3 years ago

JacobBas commented 3 years ago

Hi,

I'm currently working on a project where I would like to create new, formatted workbooks from already created and formatted workbooks.

For example, let say we have workbook1.xlsx which contains sheets ("sheet1", "sheet2", "sheet3") and workbook2.xlsx which contains sheets ("sheet4", "sheet5", "sheet6") where each sheet contains very specific formatting and data that I would like to keep constant while creating a new_workbook.xlsx that contains sheets ("sheet2", "sheet5").

Currently I know of the method cloneSheet(object, sheet, name) but this only allows for this functionality inter-workbook.

The question is if this is something that can already be done within the package or if there is some sort of workaround that can be done to get this functionality.

Thanks

cryptobiotic commented 3 years ago

I would also be interested in this functionality.

spoltier commented 3 years ago

Hi, this is not currently supported, unfortunately it doesn't look like apache POI provides the required underlying functionality - a sheet only exists in the context of a workbook.