Discover Rotifer/Spreadsheet2SQL Open Source project

Stars
11
Rank 1,694,829 (Top 34 %)
Language
JavaScript
Created over 9 years ago
Updated over 9 years ago

Rotifer

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

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

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

JavaScript

VBA

Excel VBA code

Visual Basic

SqliteVba

VBA classes written for use in Excel to interact with SQLite

Visual Basic

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:

HTML

VBA_SQL_GENERATOR

VBA

minimal_perl

Notes on Minimal Perl

Perl

databases

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

HTML

algorithms

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

Perl

mypython

Python stuff

Python

VBA_GAS_UDFs

General utility functions for Excel and Google Sheets

VBA

PostgreSQL_Applications

Shiny Apps with PostgreSQL back-end.

PLpgSQL

blog_code

All code used in blog entries from 2016 onwards.

JavaScript

MYR

R scripts

GAS_TASKS

General pieces of GAS written for specific purposes

JavaScript

Rotifer/Spreadsheet2SQL

Rotifer

Reviews

Repository Details

More Repositories