Live data from Hacker News

Show HN: Turn a Google Spreadsheet into an API

sheetsu.com

51–60 of 103 posts

Re: Show HN: Turn a Google Spreadsheet into an API

#51
post #49

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/

no. cause then eeeeeeeveryone goes "oh cool I've done the same thing." so the only take away is that people don't learn from the past. sad.

Re: Show HN: Turn a Google Spreadsheet into an API

#53
post #15

Ah 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

Is this open source anywhere or just closed beta?

Re: Show HN: Turn a Google Spreadsheet into an API

#55
post #53

Earlier 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?

Some OSS here: https://github.com/SpreadServe Sign up for the beta here: https://groups.google.com/forum/#!aboutgroup/spreadserve AWS hosted instance: http://54.148.111.119:8888 Docs: http://spreadserve.readthedocs.org/en/latest/

Re: Show HN: Turn a Google Spreadsheet into an API

#58
I recently hacked something together that's using Tabletop and React to render 'products' that can be entered into a 'database' using Google Forms:

http://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.

Post reply on HN