Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / ISpreadsheet Interface / Copy Method
Row index of start of range from which to copy
Column index of start of range from which to copy
Row index of start of range to which to copy
Column index of start of range to which to copy
Number of rows to copy
Number of columns to copy
The options indicates which data type will be performed.
The target worksheet where data will be copied to. null means the data is copied to the same worksheet.


In This Topic
Copy Method (ISpreadsheet)
In This Topic
Copies the data from a range of cells to a specified range of cells.
Syntax
'Declaration
 
Function Copy( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal toRow As Integer, _
   ByVal toColumn As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer, _
   ByVal options As ManipulationOptions, _
   Optional ByVal targetWorksheet As IWorksheet _
) As ActionResult(Of Object)
 
'Usage
 
Dim instance As ISpreadsheet
Dim row As Integer
Dim column As Integer
Dim toRow As Integer
Dim toColumn As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim options As ManipulationOptions
Dim targetWorksheet As IWorksheet
Dim value As ActionResult(Of Object)
 
value = instance.Copy(row, column, toRow, toColumn, rowCount, columnCount, options, targetWorksheet)

Parameters

row
Row index of start of range from which to copy
column
Column index of start of range from which to copy
toRow
Row index of start of range to which to copy
toColumn
Column index of start of range to which to copy
rowCount
Number of rows to copy
columnCount
Number of columns to copy
options
The options indicates which data type will be performed.
targetWorksheet
The target worksheet where data will be copied to. null means the data is copied to the same worksheet.

Return Value

true if the cell range is copied successful, false otherwise.
See Also