getRange Method

Gets a range of cells in the specified sheet area.

Syntax

Javascript (Usage)
Javascript (Specification)

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".

Reference

Worksheet type