There are no reviews yet. Be the first to send feedback to the community and the maintainers!
GoogleSpreadsheetProgramming_2015
Contains all code examples given in the 2015 version of my Leanpub book "Google Spreadsheet Programming". Each chapter is given its own GAS file (.gs).JavaScript
JavaScript and Google App Script codeVBA
Excel VBA codeSpreadsheet2SQL
GAS code to convert values in a spreadsheet to SQL statements. Header row is used to for the "CREATE TABLE" statement, data rows are used to create "INSERT" statements. Cangenerate SQLite, MySQL and PostgreSQL versions of SQLSqliteVba
VBA classes written for use in Excel to interact with SQLiteSpreadsheetToHtmlSelect
Contains GAS and HTML that shows how to use a spreadsheet named range to dynamically populate a Html Service dropdown list. See blog entry:VBA_SQL_GENERATOR
minimal_perl
Notes on Minimal Perldatabases
Notes and code snippets on databases, SQL and general database programmingalgorithms
Algorithms in Python manily but also a few in Perl and Rmypython
Python stuffVBA_GAS_UDFs
General utility functions for Excel and Google SheetsPostgreSQL_Applications
Shiny Apps with PostgreSQL back-end.blog_code
All code used in blog entries from 2016 onwards.GAS_TASKS
General pieces of GAS written for specific purposesLove Open Source and this site? Check out how you can help us