Rotifer/VBA_GAS_UDFs

Stars
1
Language VBA
Created almost 2 years ago
Updated almost 2 years ago

Rotifer/VBA_GAS_UDFs

Rotifer

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

General utility functions for Excel and Google Sheets

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 code

VBA

Spreadsheet2SQL

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 SQL

SqliteVba

VBA classes written for use in Excel to interact with SQLite

SpreadsheetToHtmlSelect

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 Perl

databases

Notes and code snippets on databases, SQL and general database programming

algorithms

Algorithms in Python manily but also a few in Perl and R

mypython

PostgreSQL_Applications

Shiny Apps with PostgreSQL back-end.

blog_code

All code used in blog entries from 2016 onwards.

MYR

GAS_TASKS

General pieces of GAS written for specific purposes