No easy way. GS only support CSV or Atom-Feed.
And if you use atom feed (json-feed) you'll find that all field/column will be in the "content" part of the json-feed.
Here are some workaround that need two phase effort:
Parse CSV output using PHP and get JSON back.
http://www.ravelrumba.com/blog/json-google-spreadsheets/
or
Use script editor and add function to Google spreadsheet
http://blog.pamelafox.org/2013/06/exporting-google-spreadsheet-as-json.html
I've also tried
thttp://pipes.yahoo.com/pipes/pipe.edit
The main problem is "Google Spreadsheet" publishing in RSS/Atom format is only for others to subscribe the document as a blog, not to retrieve its data. Period!
And if you use atom feed (json-feed) you'll find that all field/column will be in the "content" part of the json-feed.
Here are some workaround that need two phase effort:
Parse CSV output using PHP and get JSON back.
http://www.ravelrumba.com/blog/json-google-spreadsheets/
or
Use script editor and add function to Google spreadsheet
http://blog.pamelafox.org/2013/06/exporting-google-spreadsheet-as-json.html
I've also tried
thttp://pipes.yahoo.com/pipes/pipe.edit
The main problem is "Google Spreadsheet" publishing in RSS/Atom format is only for others to subscribe the document as a blog, not to retrieve its data. Period!
沒有留言:
張貼留言