Copy Table or Cells with formatting

[JBaywatch]

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.

[Flash]

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