Create a copy of workbook object

[Dmitry]

I am wondering, is there a way to create a copy of workbook object?

[Anna]

Hello,

Unfortunately, there isn't an out of the box way to create a copy of the workbook object. A possible workaround is to create a new workbook and copy each worksheet of the source workbook in it, as well as any other properties you would like to include. I've prepared a sample project illustrating this approach. It is by no means a comprehensive example, as it is limited to the content of the worksheets and the theme of the workbook. Other properties which can be included are for example the named ranges, the shapes and the name of the workbook.

I hope this helps.

Regards,
Anna
Telerik

 

 

[Dmitry]

Thank you, it will suffice for now.