Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Description

Copies an area of cells to a Worksheet from a worksheet in either the same workbook or another workbook altogether. The source and destination worksheet can also be the same worksheet.

You may specify the types of data copied (cell value, formulas, comments, formatting, etc.) using the CopyPasteProperties object.
The CopyPaste method supports copying column width, comments, formulas, merged cells, row height, values, and cell and number formatting.  

Description

Excerpt

Copies an area of cells to a Worksheet from a worksheet in either the same workbook or another workbook altogether. The source and destination worksheet can also be the same worksheet.

Signature
C#
C#
 public Area CopyPaste(int firstRow, int firstCol, Area sourceArea, CopyPasteProperties properties)

...