Spreadsheet helpers

This section provides more details about some useful methods for creating methods in your online spreadsheets.

Documentation

Methods

Method Description
getColumnName(number) Get the column letter based on a number.
jspreadsheet.helpers.getColumnName(columnNumber: Number) => String
getColumnNameFromCoords(number, number) Get the spreadsheet-like cell name from the coordinates.
jspreadsheet.helpers.getColumnName(x: Number, y: Number) => String
getCoordsFromColumnName(string) Get the coordinates from the spreadsheet-like cell name.
jspreadsheet.helpers.getCoordsFromColumnName(cellName: String) => [Number, Number]
shiftFormula(string, number, number) Update all variables from a formula based a shift of x, y positions.
jspreadsheet.helpers.shiftFormula(formula: String, x: Number, y: Number) => String
createFromTable(DOMElement, options) Extract the configuration to create a new spreadsheet from a static HTML element.
jspreadsheet.helpers.createFromTable(element: HTMLElement, options: Object) => Object
parseCSV(string, string) Transform a CSV string into an array.
jspreadsheet.helpers.parseCSV(data: String, delimiter: String) => Array
getTokensFromRange(string) Extract the tokens from a range. Example: getTokensFromRange('A1:A10'); // returns [A1,A2,A3,A4...]
jspreadsheet.helpers.getTokensFromRange(range: String) => Array
getRangeFromTokens(array) Get the range from an array of tokens.
jspreadsheet.helpers.getRangeFromTokens(tokens: Array) => String
getCoordsFromRange(string) Get the coordinates from a range string. Example: getTokensFromRange('A1:A10'); // returns [0,0,0,9]
jspreadsheet.helpers.getCoordsFromRange(range: string) => Array


Worksheets shortcut to the helpers

On the most recent versions the instance of the worksheets provides a shortcut to the helpers.