Description
Copies an area of cells from a Worksheet to either different cells in the same worksheet, cells in a different worksheet, or cells in another workbook altogether.
C#
vb.net
Parameters
firstRow
The zero-based index of the first row in destination area.firstCol
The zero-based index of the first column in the destination area.sourceArea
An area from the source workbook from which to copy.properties
A CopyPasteProperties object that specifies the types of data to copy.Returns
An Area object representing the set of cells populated with the copied values.Remarks
- The copied data will overwrite the contents of the cells in this 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.
- The CopyPaste method does not copy conditional formatting.
- When formulas are copied, references to ranges are updated to refer to the new sheet.
Examples
C#
vb.net