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.
| Excerpt |
|---|
Copies an area of cells to a Worksheet from a Worksheet to either different cells in the same worksheet, cells in a different worksheet, or cells in worksheet in either the same workbook or another workbook altogether. The source and destination worksheet can also be the same worksheet. |
| Signature |
|---|
|
public Area CopyPaste(int firstRow, int firstCol, Area sourceArea, CopyPasteProperties properties)
|
...
| 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.
|
...
