SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / moveTo Method
The source row.
The source column.
The target row.
The target column.
The row count.
The column count.
The copy option.
In This Topic
    moveTo Method
    In This Topic
    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