Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
40
How do I copy a Worksheet from one Workbook to another Workbook?
posted

We are generating SQL Server reports and rendering them to Excel format.  Each report creates a new Workbook.   We need to be able to open workbook1 and workbook2 and then copy a sheet1 from workbook2 into workbook1 as the last sheet.

We can do this using the Excel object model, but would prefer to use the Infragistics.Excel so that Office does not have to be installed on a server.

I have looked over the Infragistics.Excel documentation and do not see any API support for this. 

Any help would be appreciated. 

Kent