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
Still not?
I'm also having a problem with auto updating the chart. Hope to find the answer here.
Hi thank you for your answer. Currently I am trying to auto update a chart when I insert a new column in a worksheet. How can I do it ?
Hi,
No, there's no such feature at this time.
Hi Mark, has the feature of copying a worksheet from a workbook to another workbook been implemented yet ?
Thank you in advance