getRows Method

Gets a range of rows in the specified sheet area.

Syntax

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: Row
value = instance.getRows(index, index2, sheetArea);

function getRows( 
   index : number,
   index2 : number,
   sheetArea : SheetArea
) : Row;

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

The rows.

Example

This example sets the background color for the specified rows.

activeSheet.getRows(1,3,GcSpread.Sheets.SheetArea.viewport).backColor("yellow");
alert(rheight);

Send comments on this topic.