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

Visual Basic
C#

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

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

public void CopyTo( 
   int fromRow,
   int fromColumn,
   int toRow,
   int toColumn,
   int rowCount,
   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#
VB.NET

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

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

Target Platforms: Windows Server 2012, Windows RT

Reference

Worksheet Class
Worksheet Members