- Notifications
You must be signed in to change notification settings - Fork689
Google Spreadsheets
Mathias Rangel Wulff edited this pageApr 13, 2020 ·5 revisions
AlaSQL can query data directly from a google spreadsheet - so its easy to edit the raw data in the spreadsheet and make manipulations like grouping, filtering, or saving to XLSX directly in your app. The feature depends on the pluginTabletop library.
<scriptsrc='https://cdnjs.cloudflare.com/ajax/libs/tabletop.js/1.4.2/tabletop.min.js'></script><scriptsrc="//cdn.jsdelivr.net/alasql/0.2/alasql.min.js"></script><divid="res"></div><script>varurl='https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0AmYzu_s7QHsmdDNZUzRlYldnWTZCLXdrMXlYQzVxSFE&output=html';alasql('SELECT * INTO HTML("#res",{headers:true}) FROM TABLETOP(?) WHERE name < "D" ORDER BY category',[url]);</script>
Play with this examplein jsFiddle
Remember to publish your spreadsheet. In case of problem read thisStackoOverflow question.
More info abouttheTABLETOP keyword
© 2014-2026,Andrey Gershun &Mathias Rangel Wulff
Please help improve the documentation by opening a PR on thewiki repo