Description |
---|
Excerpt |
---|
Copies an |
area of cells |
from |
The CopyPaste method supports copying column width, comments, formulas, merged cells, row height, values, and cell and number formatting.The CopyPaste method does not currently support copying anything not listed above, including charts, images, or autofilters.
another Worksheet to cells in this worksheet. |
Signature | ||||
---|---|---|---|---|
| ||||
public Area CopyPaste(int firstRow, int firstCol, Area sourceArea, CopyPasteProperties properties) |
...
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. |
Example | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|