MCPcopy Create free account

hub / github.com/davecook88/SpreadsheetManager / functions

Functions38 in github.com/davecook88/SpreadsheetManager

↓ 3 callersMethodgetLastRow
* * * @returns array * @memberof SpreadsheetManager
SpreadsheetManager.js:119
↓ 3 callersMethodgetLastRow
* * * @returns array * @memberof SpreadsheetManager
SpreadsheetManager.ts:186
↓ 1 callersMethodaddNewRows
* * * @param variable[][] or variable[] rows * @memberof SpreadsheetManager
SpreadsheetManager.js:23
↓ 1 callersMethodaddNewRows
* * * @param variable[][] or variable[] rows * @memberof SpreadsheetManager
SpreadsheetManager.ts:60
↓ 1 callersMethodcol
(headerName, value)
SpreadsheetManager.js:238
↓ 1 callersMethodcol
( headerName: string, value?: any )
SpreadsheetManager.ts:344
↓ 1 callersMethodcreateObject
()
SpreadsheetManager.js:228
↓ 1 callersMethodcreateObject
()
SpreadsheetManager.ts:333
↓ 1 callersMethodcreateRowFromObject
(obj: SpreadsheetManagerTypes.GenericRowObject)
SpreadsheetManager.ts:135
↓ 1 callersMethodforEachRow
* * @desc loops through all rows * @param {function} callback * @param {object} options can specify 'bottomUp' as true to reverse direction o
SpreadsheetManager.js:98
↓ 1 callersMethodforEachRow
* * @desc loops through all rows * @param {function} callback * @param {object} options can specify 'bottomUp' as true to reverse directio
SpreadsheetManager.ts:155
↓ 1 callersMethodgetRowHeaders
(topRow)
SpreadsheetManager.js:141
↓ 1 callersMethodgetRowHeaders
* @desc creates an array to reference column number by header name * @param string[] topRow * @return obj - {header:int,header:int,...}
SpreadsheetManager.ts:198
↓ 1 callersMethodgetSheetValues
* @desc sets values attribute for object * @return array of data from sheet
SpreadsheetManager.js:156
↓ 1 callersMethodgetSheetValues
* @desc sets values attribute for object * @return array of data from sheet
SpreadsheetManager.ts:224
MethodaddNewRowsFromObjects
* @param Object[] Array of object representing data to be entered into each row * each attribute of each object must be equivalent to an attribute
SpreadsheetManager.js:38
MethodaddNewRowsFromObjects
* @param Object[] Array of object representing data to be entered into each row * each attribute of each object must be equivalent to an attribute
SpreadsheetManager.ts:73
MethodclearSheet
()
SpreadsheetManager.js:71
MethodclearSheet
()
SpreadsheetManager.ts:112
MethodclearSheetAndPasteValues
* * * @memberof SpreadsheetManager
SpreadsheetManager.js:84
MethodclearSheetAndPasteValues
* * * @memberof SpreadsheetManager
SpreadsheetManager.ts:127
Methodconstructor
(wb, sheetName, options)
SpreadsheetManager.js:7
Methodconstructor
*Creates an instance of _Row. * @param string[] row * @param object headers * @memberof _Row
SpreadsheetManager.js:223
Methodconstructor
( wb: GoogleAppsScript.Spreadsheet.Spreadsheet, sheetName: string, options?: SpreadsheetManager
SpreadsheetManager.ts:36
Methodconstructor
*Creates an instance of _Row. * @param string[] row * @param object headers * @memberof _Row
SpreadsheetManager.ts:321
MethodcreateObjectFromRow
* * * @param _Row[] row * @returns object of values with column headers as keys * @memberof SpreadsheetManager
SpreadsheetManager.js:58
MethodcreateObjectFromRow
* * * @param _Row[] row * @returns object of values with column headers as keys * @memberof SpreadsheetManager
SpreadsheetManager.ts:97
MethodgetRowsAsObjects
* @desc creates an array to reference column number by header name * @param string[] topRow * @return obj - {header:int,header:int,...}
SpreadsheetManager.js:132
MethodgetRowsAsObjects
()
SpreadsheetManager.ts:212
MethodgetValuesInColumn
* @desc gets values in column by column header name * @param string headerName * @param bool valuesOnly = when true, function returns 1d array.
SpreadsheetManager.js:170
MethodgetValuesInColumn
* @desc gets values in column by column header name * @param string headerName * @param bool valuesOnly = when true, function returns 1d arra
SpreadsheetManager.ts:243
MethodpasteValuesToColumn
* @desc paste formatted column into sheet by header name * @param string headerName
SpreadsheetManager.js:188
MethodpasteValuesToColumn
* @desc paste formatted column into sheet by header name * @param string headerName
SpreadsheetManager.ts:261
Methodpopulate
(obj)
SpreadsheetManager.js:252
Methodupdate
()
SpreadsheetManager.ts:363
MethodupdateAllValues
* @desc updates sheet with values from this.values;
SpreadsheetManager.js:209
MethodupdateAllValues
* @desc updates sheet with values from this.values;
SpreadsheetManager.ts:286
MethodupdateOneRow
(row: SpreadsheetManagerTypes.GenericRowObject)
SpreadsheetManager.ts:300