moveTo Method

Moves data from one range to another.

Syntax

Javascript (Usage)
Javascript (Specification)

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.

Javascript

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);

Reference

Worksheet type