Creates an empty workbook. locale, timezone and languageId default
to "en", "UTC" and "en".
Optionallocale: string | nullOptionaltimezone: string | nullOptionallanguageId: string | nullAdds a new sheet with the given name
Clears the contents of a single cell, keeping the formatting
Deletes the default style of a column
Optionalscope: number | nullDeletes the default style of a row
Evaluates the workbook
Returns all non-empty cells as a list of [sheet, row, column] tuples
Returns the content of a cell as the user would see it in the editor: the formula if there is one or the raw value otherwise
Returns the formula of a cell, if any
Returns the type of the content of a cell
Returns the value of a cell as a native JS value (null, string, number or boolean)
Returns the value of a cell referenced like "Sheet1!C4" as a native JS value (null, string, number or boolean)
Returns the default style of a column, if any
Returns the list of defined names as [{name, scope, formula}].
scope is omitted for globally scoped names.
Returns locale dependent formatting settings (currency, date formats, ...)
Returns the formatted value of a cell (i.e. "$ 5.75")
Returns the default style of a row, if any
Returns the bounds of all non-empty cells as [minRow, maxRow, minColumn, maxColumn]. For an empty sheet returns [1, 1, 1, 1].
Returns a markdown-like representation of the sheet, useful for debugging
Returns the workbook theme
Returns the list of sheets with their properties (name, state, color, ...)
Returns true if the cell is empty
Moves a column by delta positions
Moves a row by delta positions
Creates a new defined name. scope is a sheet index or null for global scope.
Adds a new sheet with an automatically generated name
Saves the workbook to a file in the internal binary ic format
Saves the workbook to an xlsx file
Sets the style of a cell from a style object
Sets the default style for a whole column
Sets the default style for a whole row
Sets the sheet tab color. Accepts null, "#RRGGBB" or [theme, tint]
Optionalcolor: Color | nullSets the sheet visibility state: "visible", "hidden" or "veryHidden"
Sets an input in a cell, parsing it as a user would type it: "3.5" is a number, "Hello" a string, "=A1*2" a formula
Returns the workbook as bytes in the internal binary ic format
Sets a boolean in a cell without input parsing
Sets a formula (i.e. "=A1*2") in a cell
Sets a number in a cell without input parsing
Sets a string value in a cell without input parsing
StaticfromCreates a model from bytes in the internal binary ic format.
This is the same format produced by saveToIcalc and toBytes.
OptionallanguageId: string | nullStaticfromCreates a model from an icalc file
OptionallanguageId: string | nullStaticfrom
A workbook model implementing the "raw" low level API. Nothing is evaluated automatically: you need to call
evaluateyourself. There is no undo/redo history and no diffs are produced.