spreadsheet
typeScript/javascript spreadsheet parser, with formulas.
git clone https://git.vogt.world/spreadsheet.git
Log | Files | README.md
← All files
name: dist/Formulas/Lookup.d.ts
-rw-r--r--
1414
 1/**
 2 * Returns an element from a list of choices based on index.
 3 * @param index - Which choice to return. Index starts at 1.
 4 * @param values -  Array of potential value to return. Required. May be a reference to a cell or an individual value.
 5 * @constructor
 6 */
 7declare let CHOOSE: (index: any, ...values: any[]) => any;
 8/**
 9 * Returns a text representation of a cell address based on the row, column, and sheet.
10 * @param row - Row of cell address.
11 * @param column - Column of cell address
12 * @param {number} absoluteVsRelativeMode - [OPTIONAL - default is 1] Should return a relative(A1, vs $A$1) or absolute address. 1 is row and
13 * column absolute (e.g. $A$1), 2 is row absolute and column relative (e.g. A$1), 3 is row relative and column absolute
14 * (e.g. $A1), 4 is row and column relative (e.g. A1).
15 * @param {boolean} useA1Notation - [OPTIONAL - default is TRUE] Should use A1 notation.
16 * @param sheet - [OPTIONAL] Sheet name to use in address.
17 * @returns {string}
18 * @constructor
19 */
20declare let ADDRESS: (row: any, column: any, absoluteVsRelativeMode?: number, useA1Notation?: boolean, sheet?: any) => string;
21/**
22 * Gets the number of columns in a specified array or range.
23 * @param value - The array of range to consider.
24 * @returns {number}
25 * @constructor
26 */
27declare let COLUMNS: (value: any) => number;
28declare let ROWS: (value: any) => number;
29export { CHOOSE, ADDRESS, COLUMNS, ROWS };