Code
Hub
Workspaces
Following
Trending
Connect
MCP
copy
Create free account
hub
/
github.com/Max-Makhrov/GoogleSheets
/ functions
Functions
186 in github.com/Max-Makhrov/GoogleSheets
⨍
Functions
186
◇
Types & classes
1
↓ 6 callers
Function
checkColDv
(col, cols, delim)
sheets/onEdit.js:154
↓ 3 callers
Function
addValuesToArray
(arr1, arr2)
data/2dArray.js:563
↓ 3 callers
Function
getEmails
(users)
drive/DriveApp.js:81
↓ 3 callers
Function
getNode
(node, row)
data/Filter2dArrays.js:488
↓ 3 callers
Function
getToken
(token, row)
data/Filter2dArrays.js:439
↓ 3 callers
Function
r
()
data/Array_Polyfills.js:92
↓ 3 callers
Function
replaceAll
(str, find, replace)
data/Strings.js:51
↓ 3 callers
Function
transpose
(a)
data/2dArray.js:29
↓ 3 callers
Function
unpivot
(head1, data1, head2, data2, labels)
data/2dArray.js:125
↓ 2 callers
Function
addTask
(keyTask, keyData, numRow, numCols, data)
sheets/Tasker.js:103
↓ 2 callers
Function
byteCount
(str)
data/Strings.js:34
↓ 2 callers
Function
chunkString
* Splits string into equal parts. * * @param {string} str The string to chunk. * @param {number} length The length of parts. * @return Array - str
data/Strings.js:9
↓ 2 callers
Function
chunkStringParts
(str, parts)
data/Strings.js:18
↓ 2 callers
Function
convertArrayToObject
(arr, keyColumns)
data/2dArray.js:823
↓ 2 callers
Function
createSheetIfNotExists
(ss, name)
sheets/Sheets.js:254
↓ 2 callers
Function
extrectColumnsByIdsFill
(data, columns)
data/2dArray.js:400
↓ 2 callers
Function
extrectColumnsFromTableData
(data, columns)
data/2dArray.js:256
↓ 2 callers
Function
fillRight2d
(arr)
data/2dArray.js:672
↓ 2 callers
Function
filter2dArray
(array, formula)
data/Filter2dArrays.js:89
↓ 2 callers
Function
get2ArraysEquals
(arr1, arr2)
data/Arrays.js:33
↓ 2 callers
Function
get2DArrayDifference
(ids, array, idIndex)
data/2dArray.js:898
↓ 2 callers
Function
getEditObject
* Test function for onEdit. Passes an event object to simulate an edit to * a cell in a spreadsheet. * * Check for updates: https://stackoverflow.c
sheets/onEdit.js:10
↓ 2 callers
Function
getFilled2DArray
(value, w, h)
data/Arrays.js:249
↓ 2 callers
Function
getFormulizer
(formula)
data/Filter2dArrays.js:238
↓ 2 callers
Function
getPropertyAsArray
(key)
other/PropertuesService.js:138
↓ 2 callers
Function
getSheetById
(fileId, sheetId)
sheets/Sheets.js:199
↓ 2 callers
Function
getSheetsInfo_
(fileId)
sheets/Sheets.js:153
↓ 2 callers
Function
getSubTaskA1Ranges
(oSubTaskRows)
sheets/Tasker.js:422
↓ 2 callers
Function
getTableDescription
(file, rHeaders)
data/DataTypes.js:93
↓ 2 callers
Function
isCallable
(fn)
data/Array_Polyfills.js:9
↓ 2 callers
Function
join2Arrays_
(index, arr1, arr2)
data/2dArray.js:1013
↓ 2 callers
Function
runFunctionByName
(name)
sheets/Importer.js:237
↓ 2 callers
Function
timingDecorator
(f, timer)
other/TimeTests.js:16
↓ 1 callers
Function
add
(arg1, arg2)
data/Filter2dArrays.js:643
↓ 1 callers
Function
addColumnsToArray
(arr1, arr2)
data/2dArray.js:530
↓ 1 callers
Function
arrayIntersection
()
data/Arrays.js:145
↓ 1 callers
Function
buildFormula
(cell, formula)
sheets/Formulas.js:155
↓ 1 callers
Function
checkEqual
(arg1, arg2)
data/Filter2dArrays.js:640
↓ 1 callers
Function
checkLess
(arg1, arg2)
data/Filter2dArrays.js:638
↓ 1 callers
Function
checkLessEqual
(arg1, arg2)
data/Filter2dArrays.js:639
↓ 1 callers
Function
checkMore
(arg1, arg2)
data/Filter2dArrays.js:636
↓ 1 callers
Function
checkMoreEqual
(arg1, arg2)
data/Filter2dArrays.js:637
↓ 1 callers
Function
checkTriggerExists
(nameFunction, triggerSourceType)
sheets/Triggers.js:32
↓ 1 callers
Function
combine2DArrays
(arrays)
data/2dArray.js:199
↓ 1 callers
Function
deleteEmptyCellsSheet_
(sheet)
sheets/Sheets.js:278
↓ 1 callers
Function
extrectColumnsByIds
(data, columns)
data/2dArray.js:336
↓ 1 callers
Function
fill
(arr, value)
data/2dArray.js:611
↓ 1 callers
Function
fillRight
(arr)
data/2dArray.js:641
↓ 1 callers
Function
filterArraysByKeyArray
(key, value, arrays)
data/Arrays.js:109
↓ 1 callers
Function
filterByCols
(columns)
data/2dArray.js:348
↓ 1 callers
Function
filterLab
(formula)
data/Filter2dArrays.js:95
↓ 1 callers
Function
flatten_
* @param {Object} obj * * @returns {Object}
utils/tabulize.js:39
↓ 1 callers
Function
get1DArray
(arr)
data/2dArray.js:78
↓ 1 callers
Function
get2DArrayColumn
(array, indx)
data/2dArray.js:467
↓ 1 callers
Function
getDataType
(value)
data/DataTypes.js:222
↓ 1 callers
Function
getDataTypes
(data)
data/DataTypes.js:183
↓ 1 callers
Function
getFieldTypes
(FieldTypes, colIds)
sheets/Importer.js:723
↓ 1 callers
Function
getFileName
(id)
drive/DriveApp.js:115
↓ 1 callers
Function
getFolders
(object)
drive/DriveApp.js:122
↓ 1 callers
Function
getFormulaTokenizer
()
data/Filter2dArrays.js:327
↓ 1 callers
Function
getFormulas
* Get 2d array with results like this: * row column formula * 1 1 = B1 + C1 * 2 1 = B2 + C2 * 3 1
sheets/Formulas.js:20
↓ 1 callers
Function
getFormulasSheets
(sheets)
sheets/Formulas.js:37
↓ 1 callers
Function
getFormulasSheets_
(data, strSheet, i)
sheets/Formulas.js:60
↓ 1 callers
Function
getFormulas_
(data, skipHeaders)
sheets/Formulas.js:85
↓ 1 callers
Function
getIsland
()
sheets/Importer.js:758
↓ 1 callers
Function
getLine
(array)
data/2dArray.js:878
↓ 1 callers
Function
getRandomArray
(n)
data/Arrays.js:193
↓ 1 callers
Function
getRandomArrayOfIntegers
(n, min, max)
data/Arrays.js:218
↓ 1 callers
Function
getRangeValuesMapR1C1
(range, values)
sheets/Ranges.js:58
↓ 1 callers
Function
getSheetsInfo
(ids)
sheets/Sheets.js:102
↓ 1 callers
Function
getSubTask
(oSubTask)
sheets/Tasker.js:317
↓ 1 callers
Function
getSubTaskRows
(oSubTask)
sheets/Tasker.js:351
↓ 1 callers
Function
getTaskMaker
(oTasks)
sheets/Tasker.js:264
↓ 1 callers
Function
isTriggerHere_
(functionName, eventType, triggerSource)
sheets/Triggers.js:63
↓ 1 callers
Function
joinArrays_
(index, arrays)
data/2dArray.js:976
↓ 1 callers
Function
leftJoinArrays
(arr1, arr2, columns1, columns2)
data/2dArray.js:736
↓ 1 callers
Function
listFilesInFolder
(id, sheetName)
drive/DriveApp.js:36
↓ 1 callers
Function
makeDvFromList
(range, list, note)
sheets/DataValidation.js:1
↓ 1 callers
Function
makeTasksFunctions
(func, sheet, ranges, data, key)
sheets/Tasker.js:224
↓ 1 callers
Function
merge2dArrays
(arrFrom, arrTo, numIdColTo, fieldTypes, columns)
sheets/Importer.js:641
↓ 1 callers
Function
multiply
(arg1, arg2)
data/Filter2dArrays.js:644
↓ 1 callers
Function
sameValueZero
(x, y)
data/Array_Polyfills.js:285
↓ 1 callers
Function
setPropertyFromNamedRange
(SS, strRange, key)
other/PropertuesService.js:87
↓ 1 callers
Function
setUserProperty
(value, key)
other/PropertuesService.js:96
↓ 1 callers
Function
toInteger
(value)
data/Array_Polyfills.js:12
↓ 1 callers
Function
toLength
(value)
data/Array_Polyfills.js:19
↓ 1 callers
Function
unpivotTable
(file, strHead1, strHead2Start, strLabels)
sheets/UnpivotTable.js:77
↓ 1 callers
Function
writeDataIntoSheet
(file, sheet, data, rowStart, colStart)
sheets/Sheets.js:40
↓ 1 callers
Function
writeSettings
()
other/PropertuesService.js:30
Function
Formulizer
()
data/Filter2dArrays.js:423
Function
Island
(From, To)
sheets/Importer.js:790
Function
ObjectOnEdit
(e)
sheets/onEdit.js:39
Function
Paster
(idsFrom, idsTo)
sheets/Importer.js:751
Function
TESTGetFormulasSheets
()
sheets/Formulas.js:29
Function
TESTaddToArray
()
data/2dArray.js:488
Function
TESTarrayCompare
()
data/Arrays.js:19
Function
TESTbyteCount
()
data/Strings.js:37
Function
TESTcheckCol
()
sheets/onEdit.js:237
Function
TESTchunkString
()
data/Strings.js:12
Function
TESTchunkStringParts
()
data/Strings.js:24
next →
1–100 of 186, ranked by callers