Sheet

The Sheet object.

Constructors

Sheet

()

Methods

activeCell

Returns the active cell in the sheet, for example, A1.

Returns

any

name

Returns the name of the sheet.

Returns

string

range

Returns a Range object based on the passed cells.

Parameters

cell

string

Returns

Range

resize

Changes the size of the rows and columns of the current sheet.

Parameters

newRows

number

The rows of the sheet after the resizing.

newCols

number

The columns of the sheet after the resizing.

showGridLines

A Boolean value which indicates if the grid lines of the sheet will be displayed.

Parameters

value?

any

Returns

any