Sheet

Premium

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