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

Fri Jun 27, 2008 4:19 pm

Hello,

The bug has been fixed, Please download latest version of Spire.XLS.
http://www.e-iceblue.com/xls/xlsdownload.htm
User avatar

Flash
 
Posts: 56
Joined: Thu Jun 29, 2006 2:34 pm

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

Return to Spire.XLS