Every year, twice a year someone posts this solution. We get it. You hack.
So? Out of the thousands of people that frequent this site, a tiny percentage of them make this, and it's cool for people that have never seen it. Also, relevant xkcd. https://xkcd.com/1053/
Show HN: Turn a Google Spreadsheet into an API
51–60 of 103 posts
Re: Show HN: Turn a Google Spreadsheet into an API
#52Re: Show HN: Turn a Google Spreadsheet into an API
#53Ah man, this is perfect! finally a way to get simple servers running with very little hassle. One major feature I would like is the ability to specify cells for I/O. Eg in some sort of "my api" console I could say "/custom_api, {stuff:A5, things:A6}, B2". Then requests to GET /custom_api would plug in the key-value of "stuff" into A5 and "things" into A6 and then respond with whatever is in B2. Once more useful featu…
You can do that with SpreadServe[1] now. Instead of Google docs it uses real Excel .xls spreadsheets and supports VBA and XLL addins. It turns your spreadsheets into async scriptable servers. There are Python & Java APIs. [1] http://spreadserve.com
Re: Show HN: Turn a Google Spreadsheet into an API
#54Re: Show HN: Turn a Google Spreadsheet into an API
#55Earlier quoted context omitted.
You can do that with SpreadServe[1] now. Instead of Google docs it uses real Excel .xls spreadsheets and supports VBA and XLL addins. It turns your spreadsheets into async scriptable servers. There are Python & Java APIs. [1] http://spreadserve.com
Is this open source anywhere or just closed beta?
Re: Show HN: Turn a Google Spreadsheet into an API
#56I would really prefer something like this to be a local library or something, adding another remote service in between negatively affects security and reliability. Especially in this case where there is no HTTPS yet.
Re: Show HN: Turn a Google Spreadsheet into an API
#57Every year, twice a year someone posts this solution. We get it. You hack.
Re: Show HN: Turn a Google Spreadsheet into an API
#58http://jsbin.com/zaberiqami/1/edit?js,output
The top part of the code is separated from the bottom plumbing, and is sprinkled with comments in Dutch for my students to edit ('8th grade', Dutch 2VWO).
I actually used it more as an example and inspiration to talk about databases in general. The group is a mix of students from the previous year; by setting the bar high and encouraging them to change the parts they knew something about, I could gauge their individual skill level a bit. Pink product listings ensued. JSBin really is an awesome tool I couldn't do without.
Re: Show HN: Turn a Google Spreadsheet into an API
#59Is there a way to get data from each sheet in a workbook? I'd love to use this, it is so simple. But it only seems to get the first sheet in my workbook.