Skip to main content

Sheet Manager API overview

NameDescription
add()Adds a new empty sheet to the spreadsheet and returns the unique identifier of the newly created sheet
clear()Clears the content of a specific sheet (removes all cell values, styles, and formatting) without deleting the sheet itself
get()Returns a single sheet object by its identifier
getActive()Returns the sheet object that is currently active (visible) in the spreadsheet
getAll()Returns an array of all sheet objects currently present in the spreadsheet
remove()Removes a sheet from the spreadsheet by its identifier
setActive()Switches the active (visible) sheet to the one specified by its identifier