WorkSheet

Class: WorkSheet

Represents a worksheet.

▸ getText(row, col): string

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

Name	Type	Description
`row`	`number`	The row index.
`col`	`number`	The column index.

string

Returns the formatted text of the cell.

Sample

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

▸ getValue(row, col): any

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

Name	Type	Description
`row`	`number`	The row index.
`col`	`number`	The column index.

any

Object Returns the value of the cell.

Sample

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

▸ getSelections(): undefined | Range[]

Retrieves the selections in the current sheet.

undefined | Range[]

The type Range is stored in an Array.

Sample

var selection = worksheet.getSelections();