1

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.

Andrei
  • 1,606
  • 4
  • 19
  • 31

2 Answers2

2

You can take a look at Dynamic FAQ Section w/ jQuery, YQL & Google Docsif you want something like this.

dragosplesca
  • 515
  • 6
  • 12
  • Thanks ! The article mentions using the Spreadsheets publishing options, from which I can then get a URL and retrieve the HTML using cURL. – Andrei Aug 19 '10 at 19:09
0

This should help you out: http://code.google.com/apis/spreadsheets/data/1.0/developers_guide_php.html

Although C# this will help too: How to download Google SpreadSheets using C#?

Community
  • 1
  • 1
Chris
  • 11,780
  • 13
  • 48
  • 70
  • 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 Aug 19 '10 at 19:08
  • 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 Aug 19 '10 at 19:22