Hacker News new | ask | show | jobs
by cpeterso 4366 days 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/1CXdwQq...

2. I load the spreadsheet's tab "1816064743" as XML: 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/gdat...

4. And display the pretty results on my website: http://arewee10syet.com/