Spire.XLS for .NET is a professional Excel .NET component that can be used to any type of .NET 2.0, 3.5, 4.0 or 4.5 framework application, both ASP.NET web sites and Windows Forms application.

Sat Oct 23, 2010 5:21 pm

I am trying to figure out how to copy a Table between Worksheets.

Using NPOI, I iterated the cells row by row and column by column and copied them into another Worksheet at the same cell address.
I can't seem to figure out how to do that here.

Any help is greatly appreciatted, demo is due Monday morning and NPOI let me down, so I need to find an alternative API.

JBaywatch
 
Posts: 1
Joined: Sat Oct 23, 2010 5:01 pm

Mon Oct 25, 2010 1:48 pm

Hello,

Thank you for your inquiry.

Please use following source code to copy cells between difference workbook.
Code: Select all
srcSheet.Range[i,i].Copy(destSheet.Range[i, i], false,true);

Look up attachment for your reference.

Please let me know if you have any questions and concerns.

Best Regards
Attachments
CopyCells.zip
(13.2 KiB) Downloaded 354 times
User avatar

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

Return to Spire.XLS