I'm thinking that someone might of already solved this problem. I tried to look at the Spreadsheets API and there's no mention of being able to download the file. cURL might be an option but I'd rather not get into the hassle of authenticating / POSTing manually.
A:
This should help you out: http://code.google.com/apis/spreadsheets/data/1.0/developers_guide_php.html
Although C# this will help too: http://stackoverflow.com/questions/943995/how-to-download-google-spreadsheets-using-c
Chris
2010-08-19 18:50:15
I had looked to the Spreadsheets API and it's only returning data as XML, which I would then need to transform to HTML. The SO answer however is interesting, although I guess I'll use the much simpler solution I've read in the article the @dragosplesca mentioned, which is using the publishing options to set an URL for the spreadsheet.
Andrei
2010-08-19 19:08:25
Sounds good cheers mate, I believe the reason you are only seeing xml is because that is how google is storing your spreadsheet data.
Chris
2010-08-19 19:22:12
A:
You can take a look at Dynamic FAQ Section w/ jQuery, YQL & Google Docsif you want something like this.
dragosplesca
2010-08-19 18:54:47
Thanks ! The article mentions using the Spreadsheets publishing options, from which I can then get a URL and retrieve the HTML using cURL.
Andrei
2010-08-19 19:09:52