Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.
Mon Jun 23, 2008 7:45 am
Hi!
I'm trying to copy a worksheet form a workbook to another.
- Code: Select all
Workbook w1 = new workbook();
Workbook w2 = new workbook();
w1.LoadFromFile("C:\\Templates\\Template.xls");
w2.Worksheets.AddCopy(w1.Worksheets[0]);
Here i got the ApplicationException "Cannot find required constructor". With an older version of Spire.XLS this worked without problems, where there any changes?
-
pb
-
- Posts: 14
- Joined: Fri Jun 20, 2008 11:05 am
Mon Jul 07, 2008 7:09 am
Hi!
I've updated to the newest Version (VisualStudio shows 'Runtimeversion v2.0.50727).
The problem still remains. I'm not able to add a copy of a worksheet to another. I tried different parameter combinations for AddCopy(). Each shows the earlier mentioned exception.
BTW: what shows the enum WorksheetCopyType? I couldn't find any clue in the demos or the help file.
-
pb
-
- Posts: 14
- Joined: Fri Jun 20, 2008 11:05 am