Copy Table or Cells with formatting

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Copy Table or Cells with formatting

Postby JBaywatch » 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

Re: Copy Table or Cells with formatting

Postby Flash » 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 314 times
User avatar
Flash
 
Posts: 56
Joined: Thu Jun 29, 2006 2:34 pm


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests