Add worksheet from one workbook to another.

Apr 27, 2012 at 4:03 PM
Edited Apr 27, 2012 at 4:03 PM

 

I'm getting a index out of range when trying to copy a worksheet from one workbook to another.  I'm using two different packages.  Is this possible?

 

templatePackage.Workbook.Worksheets.Add(SpreadsheetTabs.RESULTS, package.Workbook.Worksheets[SpreadsheetTabs.RESULTS]);
Coordinator
May 2, 2012 at 6:19 PM

Hi,

It's intended to work (in the latest version).

Create an issue with your code and the workbooks so I can have a look at it'

Jan