Class: WorkSheet

Represents a worksheet.

Methods

getSelections()

getSelections(): Range[]

Retrieves the selections in the current sheet.

Returns

Range[]

The type Range is stored in an Array.

Sample

var selection = worksheet.getSelections();

getText()

getText(row, col): string

Retrieves formatted text in the cell based on the desired row and column index.

Parameters

row

number

The row index.

col

number

The column index.

Returns

string

Returns the formatted text of the cell.

Sample

var text = worksheet.getText(0, 0);

getValue()

getValue(row, col): any

Retrieves unformatted data from the specified cell based on the desired row and column index.

Parameters

row

number

The row index.

col

number

The column index.

Returns

any

Object Returns the value of the cell.

Sample

var value = worksheet.getValue(0, 0);