neoGSheets
Google sheets data loader 2.1
Based on:
https://github.com/chriszarate/sheetrock
Valid querys:
https://developers.google.com/chart/interactive/docs/querylanguage
More info:
https://visualneo.com/forum/topic/neogsheets-google-sheets-plugin
Sample App:
https://visualneo.com/tutorials/neogsheets
neoGSheetsLoad
|
Purpose: |
Load Google Sheets data into an Array of JSON objects Query sampe: select A,B,C where E = 'VAL' order by L desc |
|
Category: |
neoGSheets |
|
Syntax: |
neoGSheetsLoad "gsheets" theArray "sqlquery" subroutine
gsheets Public Google sheet URL theArray JSON data object to store the data sqlquery Query (optional) subroutine Callback subroutine (optional) |
neoGSheetsLoadColumn
|
Purpose: |
Load Google Sheets data into an Array of JSON objects Query sampe: select A,B,C where E = 'VAL' order by L desc |
|
Category: |
neoGSheets |
|
Syntax: |
neoGSheetsLoadColumn "gsheets" theArray "columnLetter" subroutine
gsheets Public Google sheet URL theArray Array to store the data columnLetter Column letter (A,B,C...) subroutine Callback subroutine (optional) |
neoGSheetsLoadCell
|
Purpose: |
Load Google Sheets data into an Array of JSON objects Query sampe: select A,B,C where E = 'VAL' order by L desc |
|
Category: |
neoGSheets |
|
Syntax: |
neoGSheetsLoadCell "gsheets" myVariable "columnLetter" rowNumber subroutine
gsheets Public Google sheet URL myVariable Variable to store the data columnLetter Column letter (A,B,C...) rowNumber Row number subroutine Callback subroutine (optional) |
neoGSheetsLoadAsTable
|
Purpose: |
Load Google Sheets data into an Array of JSON objects Query sampe: select A,B,C where E = 'VAL' order by L desc |
|
Category: |
neoGSheets |
|
Syntax: |
neoGSheetsLoadAsTable "objId" "gsheets" "sqlquery" subroutine
objId Container to show the data gsheets Public Google sheet URL sqlquery Query (optional) subroutine Callback subroutine (optional) |
neoGSheetsLoadByName
|
Purpose: |
Load Google Sheets data into an Array of JSON objects Query sampe: select @@name,@@profession,@@email where @@age > 55 order by @@salary desc |
|
Category: |
neoGSheets |
|
Syntax: |
neoGSheetsLoadByName "gsheets" theArray "fieldPrefix" "sqlquery" subroutine
gsheets Public Google sheet URL theArray JSON data object to store the data fieldPrefix characters used before fieldNames in sqlquery sqlquery Query (optional) subroutine Callback subroutine (optional) |