If I were you, I'd publish the spreadsheet as CSV from the Spreadsheets UI, and then use that URL to pull in the sheet via JavaScript. Once you had it via JavaScript, you could generate the table on the fly.
-Vic On Fri, Apr 8, 2011 at 1:18 PM, qiz <[email protected]> wrote: > Hi all, > I have a Wordpress website & want to have pages on the website that > retrieve data from a Google spreadsheet & display in a nice way on the > webpage e.g. not like an imbedded spreadsheet, or chart, but like an HTML > table format. > The original data is in Google spreadsheets & Fusion tables which will be > regularly updated , so I would like the website pages to update whenever the > original data is updated. > I have created a nice Google map from the Fusion table data, have got the > place markers the way I like & also the info in the popup balloons > configured as I like, and have imbedded that map on the Wordpress site. > I now would like to figure out how to create some pages on the website, > that use data from the spreadsheet tables, I think I need PHP code to do > this?? > > I only know a bit of HTML & am fairly new to spreadsheets & Fusion also, > so need some help , any advice welcome. > thanks very much! > >
