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 |