getCells Method

Gets a range of cells in the specified sheet area.

Syntax

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: Cell
value = instance.getCells(row, col, row2, col2, sheetArea);

function getCells( 
   row : number,
   col : number,
   row2 : number,
   col2 : number,
   sheetArea : SheetArea
) : Cell;

row: The row index.
col: The column index.
row2: The second row index.
col2: The second column index.
sheetArea: The sheet area. If this parameter is not given, it defaults to viewport.

The cells.

Example

This example sets data for the specified range of cells.

activeSheet.getCells(1,1, 2, 2).text("cell object");

Send comments on this topic.