OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 5

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version Current

changes.mady.by.user Wiki Administrator

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

Copies an area of cells from another Worksheet to cells in this worksheet.

Signature
C#
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
{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#}
Parameters
Param
destCell
destCell

A string indicating the upper-left cell of the destination area.

Param
sourceArea
sourceArea

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
titleC#


          //--- 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} {code:
 Code Block
vb.net
|title=
vb.net
titlevb.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}