getColumns Method

Gets a range of columns in the specified sheet area.

Syntax

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

function getColumns( 
   index : number,
   index2 : number,
   sheetArea : SheetArea
) : Column;

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

The columns.

Example

This example sets the background color for the specified columns.

activeSheet.getColumns(1, 2, GcSpread.Sheets.SheetArea.viewport).backColor("red");

Send comments on this topic.