Spread.Sheets Documentation
moveTo Method
The source row.
The source column.
The target row.
The target column.
The row count.
The column count.
The copy option.
Moves data from one range to another.
Syntax
var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: any
value = instance.moveTo(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount, option);
function moveTo( 
   fromRow : number,
   fromColumn : number,
   toRow : number,
   toColumn : number,
   rowCount : number,
   columnCount : number,
   option : CopyToOptions
) : any;

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.
Example
This example moves the data to the specified location.
activeSheet.getCell(0,0).value("A1");
activeSheet.getCell(1,1).value("Test")
activeSheet.moveTo(0,0,3,3,2,2,GC.Spread.Sheets.CopyToOptions.value);
See Also

Reference

Worksheet type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.