Spread.Sheets Documentation
getRange Method
GC.Spread.Sheets Namespace > Worksheet type : getRange Method
The row index.
The column index.
The row count of the range. If you do not provide this parameter, it defaults to 1.
The column count of the range. If you do not provide this parameter, it defaults to 1.
The sheet area. If this parameter is not given, it defaults to viewport.
Gets a range of cells in the specified sheet area.
Syntax
var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: CellRange
value = instance.getRange(row, col, rowCount, colCount, sheetArea);
function getRange( 
   row : number,
   col : number,
   rowCount : number,
   colCount : number,
   sheetArea : SheetArea
) : CellRange;

Parameters

row
The row index.
col
The column index.
rowCount
The row count of the range. If you do not provide this parameter, it defaults to 1.
colCount
The column count of the range. If you do not provide this parameter, it defaults to 1.
sheetArea
The sheet area. If this parameter is not given, it defaults to viewport.

Return Value

The cellRange. If row is -1 and rowCount is -1, the range represents columns. For example, sheet.getRange(-1,4,-1,6) returns the columns "E:J". If col is -1 and colCount is -1, the range represents rows. For example, sheet.getRange(4,-1,6,-1) returns the rows "5:10".
See Also

Reference

Worksheet type