...
Description |
---|
Excerpt |
---|
Copies an area of cells from a Worksheet in either the same workbook or another workbook. |
Signature | ||||
---|---|---|---|---|
| ||||
public Area CopyPaste(int firstRow, int firstCol, Area sourceArea, CopyPasteProperties properties)
{signature}
{signature: |
Signature | ||||||
---|---|---|---|---|---|---|
| }
| |||||
Public Function CopyPaste(ByVal firstRow As Integer, ByVal firstCol As Integer, ByVal sourceArea As Area, ByVal properties As CopyPasteProperties) As Area
{signature}
{parameters}
{param:firstRow}The zero\-based index of the first row in destination area.{param}
{param:firstCol}The zero\-based index of the first column in the destination area.{param}
{param:sourceArea}An area from the source workbook from which to copy.{param}
{param:properties}A [CopyPasteProperties|CopyPasteProperties] object that specifies the types of data to copy.{param}
{returns}An [Area|Area] object representing the set of cells populated with the copied values.{returns}
{remarks}
* The copied data will +overwrite+ the contents of the cells in this worksheet.
* The CopyPaste method does not copy conditional formatting.
* When formulas are copied, references to ranges are updated to refer to the new sheet.
{remarks}
{example}{code:csharp|title=C#} |
Parameters |
---|
Param | ||||
---|---|---|---|---|
| ||||
The zero-based index of the first row in destination area. |
Param | ||||
---|---|---|---|---|
| ||||
The zero-based index of the first column in the destination area. |
Param | ||||
---|---|---|---|---|
| ||||
An area from the source workbook from which to copy. |
Param | ||||
---|---|---|---|---|
| ||||
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 |
---|
|
Example | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|