Code
Hub
Workspaces
Following
Trending
Connect
MCP
copy
Create free account
hub
/
github.com/davecook88/SpreadsheetManager
/ functions
Functions
38 in github.com/davecook88/SpreadsheetManager
⨍
Functions
38
◇
Types & classes
13
↓ 3 callers
Method
getLastRow
* * * @returns array * @memberof SpreadsheetManager
SpreadsheetManager.js:119
↓ 3 callers
Method
getLastRow
* * * @returns array * @memberof SpreadsheetManager
SpreadsheetManager.ts:186
↓ 1 callers
Method
addNewRows
* * * @param variable[][] or variable[] rows * @memberof SpreadsheetManager
SpreadsheetManager.js:23
↓ 1 callers
Method
addNewRows
* * * @param variable[][] or variable[] rows * @memberof SpreadsheetManager
SpreadsheetManager.ts:60
↓ 1 callers
Method
col
(headerName, value)
SpreadsheetManager.js:238
↓ 1 callers
Method
col
( headerName: string, value?: any )
SpreadsheetManager.ts:344
↓ 1 callers
Method
createObject
()
SpreadsheetManager.js:228
↓ 1 callers
Method
createObject
()
SpreadsheetManager.ts:333
↓ 1 callers
Method
createRowFromObject
(obj: SpreadsheetManagerTypes.GenericRowObject)
SpreadsheetManager.ts:135
↓ 1 callers
Method
forEachRow
* * @desc loops through all rows * @param {function} callback * @param {object} options can specify 'bottomUp' as true to reverse direction o
SpreadsheetManager.js:98
↓ 1 callers
Method
forEachRow
* * @desc loops through all rows * @param {function} callback * @param {object} options can specify 'bottomUp' as true to reverse directio
SpreadsheetManager.ts:155
↓ 1 callers
Method
getRowHeaders
(topRow)
SpreadsheetManager.js:141
↓ 1 callers
Method
getRowHeaders
* @desc creates an array to reference column number by header name * @param string[] topRow * @return obj - {header:int,header:int,...}
SpreadsheetManager.ts:198
↓ 1 callers
Method
getSheetValues
* @desc sets values attribute for object * @return array of data from sheet
SpreadsheetManager.js:156
↓ 1 callers
Method
getSheetValues
* @desc sets values attribute for object * @return array of data from sheet
SpreadsheetManager.ts:224
Method
addNewRowsFromObjects
* @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
Method
addNewRowsFromObjects
* @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
Method
clearSheet
()
SpreadsheetManager.js:71
Method
clearSheet
()
SpreadsheetManager.ts:112
Method
clearSheetAndPasteValues
* * * @memberof SpreadsheetManager
SpreadsheetManager.js:84
Method
clearSheetAndPasteValues
* * * @memberof SpreadsheetManager
SpreadsheetManager.ts:127
Method
constructor
(wb, sheetName, options)
SpreadsheetManager.js:7
Method
constructor
*Creates an instance of _Row. * @param string[] row * @param object headers * @memberof _Row
SpreadsheetManager.js:223
Method
constructor
( wb: GoogleAppsScript.Spreadsheet.Spreadsheet, sheetName: string, options?: SpreadsheetManager
SpreadsheetManager.ts:36
Method
constructor
*Creates an instance of _Row. * @param string[] row * @param object headers * @memberof _Row
SpreadsheetManager.ts:321
Method
createObjectFromRow
* * * @param _Row[] row * @returns object of values with column headers as keys * @memberof SpreadsheetManager
SpreadsheetManager.js:58
Method
createObjectFromRow
* * * @param _Row[] row * @returns object of values with column headers as keys * @memberof SpreadsheetManager
SpreadsheetManager.ts:97
Method
getRowsAsObjects
* @desc creates an array to reference column number by header name * @param string[] topRow * @return obj - {header:int,header:int,...}
SpreadsheetManager.js:132
Method
getRowsAsObjects
()
SpreadsheetManager.ts:212
Method
getValuesInColumn
* @desc gets values in column by column header name * @param string headerName * @param bool valuesOnly = when true, function returns 1d array.
SpreadsheetManager.js:170
Method
getValuesInColumn
* @desc gets values in column by column header name * @param string headerName * @param bool valuesOnly = when true, function returns 1d arra
SpreadsheetManager.ts:243
Method
pasteValuesToColumn
* @desc paste formatted column into sheet by header name * @param string headerName
SpreadsheetManager.js:188
Method
pasteValuesToColumn
* @desc paste formatted column into sheet by header name * @param string headerName
SpreadsheetManager.ts:261
Method
populate
(obj)
SpreadsheetManager.js:252
Method
update
()
SpreadsheetManager.ts:363
Method
updateAllValues
* @desc updates sheet with values from this.values;
SpreadsheetManager.js:209
Method
updateAllValues
* @desc updates sheet with values from this.values;
SpreadsheetManager.ts:286
Method
updateOneRow
(row: SpreadsheetManagerTypes.GenericRowObject)
SpreadsheetManager.ts:300