2 ms·
I am using Google Spreadsheet as a simple back-end just using client-side JS (on a website to track testing of Firefox add-ons). I've been meaning to write a bl
by cpeterso 12y ago
I am using Google Spreadsheet as a simple back-end just using client-side JS (on a website to track testing of Firefox add-ons). I've been meaning to write a blog post about this because the existing blog posts I read each missed some details about parsing the spreadsheet data or accessing different spreadsheet tabs.
1. My data is on this spreadsheet:
https://docs.google.com/a/mozilla.com/spreadsheets/d/1CXdwQqNm5nqBDDfZcEoG90SLHAtb-mfMH4eAjDrFAMY/edit#gid=1816064743 https://docs.google.com/a/mozilla.com/spreadsheets/d/1CXdwQq...
2. I load the spreadsheet's tab "1816064743" as XML:
https://github.com/cpeterso/arewee10syet/blob/master/index.html#L18 https://github.com/cpeterso/arewee10syet/blob/master/index.h...
3. Then parse the spreadsheet rows and columns here:
https://github.com/cpeterso/arewee10syet/blob/master/js/gdata.js https://github.com/cpeterso/arewee10syet/blob/master/js/gdat...
4. And display the pretty results on my website:
http://arewee10syet.com/ http://arewee10syet.com/