neoSql
Perform complex SQL queries on .xlsx and .csv documents. Read only. No server side code but Web Server is mandatory to avoid CORS.
Based on:
Sample App:
https://visualneo.com/tutorials/neosql
neoSqlExcel
|
Purpose: |
Perfom a query in an Excel spreadsheet |
|
Category: |
neoSql |
|
Syntax: |
neoSqlExcel "fileName" "sheetName" ""query" objVar callBackSub
fileName File name (ie: mydoc.xlsx) sheetName Sheet name "query Query (ie: ""select * from ? where age > 20"")" objVar Object variable to strore results callBackSub Callback subroutine (optional) |
neoSqlSaveExcel
|
Purpose: |
Save a variable data object as .xlsx file |
|
Category: |
neoSql |
|
Syntax: |
neoSqlSaveExcel "fileName" objVar
fileName File name (ie: mydoc.xlsx) objVar Data object variable |
neoSqlCsv
|
Purpose: |
Perfom a query in a CSV data file |
|
Category: |
neoSql |
|
Syntax: |
neoSqlCsv "fileName" ""query" ""separator" objVar callBackSub
fileName File name (ie: mydoc.xlsx) "query Query (ie: ""select * from ? where age > 20"")" "separator Field separator character (ie: "","")" objVar Object variable to strore results callBackSub Callback subroutine (optional) |
neoSqlSaveCsv
|
Purpose: |
Save a variable data object as .csv file |
|
Category: |
neoSql |
|
Syntax: |
neoSqlSaveCsv "fileName" ""separator" ""quote" objVar
fileName File name (ie: mydoc.csv) "separator Field separator character (ie: "","")" "quote String used to quote strings (ie: "" ' "")" objVar Data object variable |
neoSqlSaveHtml
|
Purpose: |
Save a variable data object into a Container object as HTML |
|
Category: |
neoSql |
|
Syntax: |
neoSqlSaveHtml "containerId" objVar
containerId Select a Container object objVar Data object variable |
neoSqlGSheets
|
Purpose: |
Perfom a query in a Google Sheets published spreadsheet. Web server NOT necessary. IMPORTANT: Sheet must be published to allow neoSql access (File >Publish) |
|
Category: |
neoSql |
|
Syntax: |
neoSqlGSheets "fileURL" ""query" objVar callBackSub
fileURL Google Sheet URL "query Query (ie: ""select * from ? where age > 20"")" objVar Object variable to strore results callBackSub Callback subroutine (optional) |