CopyTo(Int32,Int32,Int32,Int32,Int32,Int32,CopyToOption) Method

Visual Basic
C#

'Declaration
 
Public Sub CopyTo( _
   ByVal fromRow As System.Integer, _
   ByVal fromColumn As System.Integer, _
   ByVal toRow As System.Integer, _
   ByVal toColumn As System.Integer, _
   ByVal rowCount As System.Integer, _
   ByVal columnCount As System.Integer, _
   ByVal option As CopyToOption _
)

'Usage
 
Dim instance As Worksheet
Dim fromRow As System.Integer
Dim fromColumn As System.Integer
Dim toRow As System.Integer
Dim toColumn As System.Integer
Dim rowCount As System.Integer
Dim columnCount As System.Integer
Dim option As CopyToOption
 
instance.CopyTo(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount, option)

public void CopyTo( 
   System.int fromRow,
   System.int fromColumn,
   System.int toRow,
   System.int toColumn,
   System.int rowCount,
   System.int columnCount,
   CopyToOption option
)

Parameters

fromRow: The source row.
fromColumn: The source column.
toRow: The target row.
toColumn: The target column.
rowCount: The row count.
columnCount: The column count.
option: The copy option.

This example uses the CopyTo method.

C#

gcSpreadSheet1.Sheets[0].Cells[0, 0, 2, 2].Text = "Test";
gcSpreadSheet1.Sheets[0].CopyTo(0, 0, 3, 3, 2, 2, GrapeCity.Windows.SpreadSheet.Data.CopyToOption.Value);

VB.NET

GcSpreadSheet1.Sheets(0).Cells(0, 0, 2, 2).Text = "Test"
GcSpreadSheet1.Sheets(0).CopyTo(0, 0, 3, 3, 2, 2, GrapeCity.Windows.SpreadSheet.Data.CopyToOption.Value)

Reference

Worksheet Class
Worksheet Members