Skip to content

AlaSQLGS is a library that enables the use of the AlaSQL.js library in Google Apps Script

License

Notifications You must be signed in to change notification settings

oshliaer/alasqlgs

Repository files navigation

AlaSQLGS

AlaSQLGS is a library that enables the use of the AlaSQL.js library in Google Apps Script. API docs are available here.

Adding the library to your project

AlaSQL for Google Apps Script is made available as a script library. This is how you add it to your project:

  1. Click "Add a library" in the Libraries section of the left pane in the Apps Script IDE.
  2. Enter the project key (1XWR3NzQW6fINaIaROhzsxXqRREfKXAdbKoATNbpygoune43oCmez1N8U) in the "Script ID" field, and click "Look up".
  3. Select the highest version number, and choose AlaSQL as the identifier. (Do not turn on Development Mode unless you know what you are doing. The development version may not work)
  4. Press "Add". You can now use the AlaSQL library in your code.

Loading the library

To load AlaSQLGS:

const alasql = AlaSQLGS.load();

The library supports lazzy loading.

Copying the library

A Google Apps Script project for AlaSQL is available here.

  1. Select Overview left pane in the Apps Script IDE.
  2. In the upper right corner find the copy icon.

Samples

Data and code

Links

License

AlaSQLGS for Google Apps Script is released under the MIT license.