copyTo Method

Copies 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.copyTo(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount, option);

function copyTo( 
   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 copies data to the specified location.

Javascript

activeSheet.getCell(0,0).value("1");
activeSheet.copyTo(0,0,1,1,2,2,GC.Spread.Sheets.CopyToOptions.value);

Reference

Worksheet type