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.

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 597 times
User avatar

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

Return to Spire.XLS