Spire.XLS is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application and Java (J2SE and J2EE) 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.

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

Mon Oct 25, 2010 1:48 pm


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
(13.2 KiB) Downloaded 493 times
User avatar

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

Return to Spire.XLS