Screen scraping Google Spreadsheets exported as HTML
03 Nov 2007
Glad you asked, because I've got just the solution for you. It requires using Prototype, though you could use it with just about any other library which lets you use CSS selectors.
First, create an array with which to store your data:
Then, you'll have want to create a function which takes the raw HTML input and parses it into a set of objects:
Then, just pull up the document with an Ajax call: