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

 public Area CopyPaste(System.String destCell, Area sourceArea)
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.

An Area object representing the set of cells populated with the copied values.

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.


          //--- 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);
        

          '--- 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)