-
Notifications
You must be signed in to change notification settings - Fork 665
TABLETOP
Mathias Rangel Wulff edited this page Jun 11, 2015
·
1 revision
TABLETOP
is used as a plugin to read data from google spreadsheets
It takes one argument. The argument must be the URL to the html version of a published google spreadsheet.
There are 2 ways of providing the argument.
a) By giving the URL as parameter to AlaSQL with ?
in the TABLETOP funktion
var url='https://docs.google.com/spreadsheets/d/12VlQDuE1hgArpsJFBHlVbe4XN3CX5qwHvo-58ClMGzU/pubhtml';
alasql('SELECT * INTO HTML("#res",{headers:true}) FROM TABLETOP(?)',[url]);
b) Place the value directly in the query string
alasql('SELECT * FROM TABLETOP("https://docs.google.com/spreadsheets/d/12VlQDuE1hgArpsJFBHlVbe4XN3CX5qwHvo-58ClMGzU/pubhtml")');
© 2014-2024, Andrey Gershun & Mathias Rangel Wulff
Please help improve the documentation by opening a PR on the wiki repo