GrapeCity.Xaml.SpreadSheet.Data
MoveTo(Int32,Int32,Int32,Int32,Int32,Int32,CopyToOption) Method
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > Worksheet Class : MoveTo(Int32,Int32,Int32,Int32,Int32,Int32,CopyToOption) Method
The source row.
The source column.
The target row.
The target column.
The row count.
The column count.
The move option.
Moves data from one range to another.
Syntax
'Declaration
 
Public Sub MoveTo( _
   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.MoveTo(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount, option)
public void MoveTo( 
   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 move option.
Example
This example uses the MoveTo method.
gcSpreadSheet1.Sheets[0].Cells[0, 0, 2, 2].Text = "test";
gcSpreadSheet1.Sheets[0].Cells[0, 0].Tag = "Tag 1";
gcSpreadSheet1.Sheets[0].MoveTo(0, 0, 5, 5, 2, 2, GrapeCity.Xaml.SpreadSheet.Data.CopyToOption.All);
GcSpreadSheet1.Sheets(0).Cells(0, 0, 2, 2).Text = "test"
GcSpreadSheet1.Sheets(0).Cells(0, 0).Tag = "Tag 1"
GcSpreadSheet1.Sheets(0).MoveTo(0, 0, 5, 5, 2, 2, GrapeCity.Xaml.SpreadSheet.Data.CopyToOption.All)
See Also

Reference

Worksheet Class
Worksheet Members