Excerpt |
---|
Copies an area of cells from another Worksheet to cells in this worksheet. |
Signature |
---|
C# | C# | Wiki Markup |
---|
{description}
{excerpt}Copies an area of cells from another [Worksheet|Worksheet] to cells in this worksheet.
{excerpt}
{signature:C#}
public Area CopyPaste(System.String destCell, Area sourceArea)
|
Signature |
---|
{signature}{signature:vb.net | vb.net | }
Public Function CopyPaste(ByVal destCell As String, ByVal sourceArea As Area) As Area
|
...
A string indicating the upper-left cell of the destination area.
...
An area from the source workbook from which 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. The method behaves as if you had passed in CopyPasteProperties object initialized with CopyPasteType.All. |
Example |
---|
Code Block |
---|
| csharp | csharp |
title | C# |
---|
{signature}
{parameters}
{param:destCell}A string indicating the upper\-left cell of the destination area.{param}
{param:sourceArea}An area from the source workbook from which 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 method behaves as if you had passed in CopyPasteProperties object initialized with [CopyPasteType.All|CopyPasteProperties.CopyPasteType#All].
{remarks}
{example}{code:csharp|title=C#}
//--- Open the workbook and worksheet from which we will copy cells.
Workbook sourceWb = xla.Open("MyDataSource.xls");
Worksheet sourceWs = sourceWb[0];
//--- Create the workbook and and get the worksheet
//--- into which we will paste cells.
Workbbok destWb = xla.Create("MyNewWorkbook");
Worksheet destWs = destWb[0];
//--- Define the area of cells to copy.
Area srcArea = sourceWs.CreateArea("A1:F20");
//--- Paste the data onto the destination worksheet.
//--- Copy all supported data types (excluding row height and column width).
destWs.CopyPaste("A1", srcArea);
Code Block |
---|
{code}
{code:vb.net
vb.net | title | |title=vb.net
}
'--- Open the workbook and worksheet from which we will copy cells.
Dim sourceWb As Workbook = xla.Open("MyDataSource.xls")
Dim sourceWs As Worksheet = sourceWb(0)
'--- Create the workbook and and get the worksheet
'--- into which we will paste cells.
Dim destWb As Workbook = xla.Create("MyNewWorkbook")
Dim destWs As Worksheet = destWb(0)
'--- Define the area of cells to copy.
Dim srcArea As Area = sourceWs.CreateArea("A1:F20")
'--- Paste the data onto the destination worksheet.
'--- Copy all supported data types (excluding row height and column width).
destWs.CopyPaste("A1", srcArea)
{code}
{example}