Clone across excel files

[JacobBas]

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]

I would also be interested in this functionality.

[spoltier]

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.