Skip to main content

Methods overview

NameDescription
addColumn() Adds a new column into the spreadsheet
addRow()Adds a new row into the spreadsheet
addSheet()Adds a new sheet into the spreadsheet
clear()Clears a spreadsheet
clearSheet()Clears a sheet
deleteColumn()Removes a column from the spreadsheet
deleteRow()Removes a row from the spreadsheet
eachCell()Iterates cells in the spreadsheet
endEdit()Finishes editing in the selected cell, closes editor and saves the entered value
getActiveSheet()Returns the sheet that is currently active
getFormat()Returns the number format applied to the value of a cell
getFormula()Returns the formula of a cell
getSheets()Gets all sheets of the spreadsheet
getStyle()Returns styles applied to a cell(s)
getValue()Returns the value(s) of a cell(s)
isLocked()Checks whether a cell(s) is(are) locked
load()Loads data from an external file
lock()Locks the specified cell
parse()Loads data into spreadsheet from a local data source
redo()Applies the reverted action once again
removeSheet()Removes a sheet from the spreadsheet by its id
serialize()Serializes data of spreadsheet into a JSON object
setActiveSheet()Sets the active sheet by its id
setFormat()Sets a specified format to the value of a cell
setStyle()Sets style to a cell(s)
setValidation()Sets validation for cells via adding drop-down lists into the cells
setValue()Sets a value for a cell
startEdit()Starts editing in the selected cell
undo()Reverts the latest action
unlock()Unlocks a locked cell(s)