Popular repositories Loading

1. GoogleSpreadsheetProgramming_2015 GoogleSpreadsheetProgramming_2015 Public

   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 86 62

2. JavaScript JavaScript Public

   JavaScript and Google App Script code

   JavaScript 30 61

3. VBA VBA Public

   Excel VBA code

   Visual Basic 29 13

4. Spreadsheet2SQL Spreadsheet2SQL Public

   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 an…

   JavaScript 11 3

5. SqliteVba SqliteVba Public

   VBA classes written for use in Excel to interact with SQLite

   Visual Basic 8 1

6. SpreadsheetToHtmlSelect SpreadsheetToHtmlSelect Public

   Contains GAS and HTML that shows how to use a spreadsheet named range to dynamically populate a Html Service dropdown list. See blog entry:

   HTML 4 5