Feb 18 2011, 03:24 AM
Hello everyone, I hope someone is able to help guide me through what I want to accomplish.
My goal is to create a table that is filled automatically from a published googledocs spreadsheet.
Embedding a googledocs spreadsheet using an iframe looks horrible and I could not find any way to customise its appearance (if there is a way then that could be an alternative and I would be interested).
So, what I want to do is publish the googledocs spreadsheet as a file (publishing options are .csv .txt .pdf ATOM RSS .xls or .ods) and then use the data in that file to fill out a table in a web page on my site so that I can customise the table appearance.
The data in the published googledocs spreadsheet will change from time to time so will need to collect the data each time someone views the web page that the table will be on.
If someone is able to and willing to try help me then please ask for any more information you would require.
Thanks so much in advance.
[this is to create a dynamic member roster for my gaming guild]
Feb 18 2011, 07:47 AM
I don't know if this can be done, but I know it can't be done with HTML. It would take a server side program. Are you still game? If so I can move the thread to the server-side scripting forum for you.
Feb 18 2011, 02:20 PM
How dynamic do you want the data to be? That is, if someone updates the Google Docs spreadsheet, do you want the web site updated automatically as soon as the changes are saved to the spreadsheet? Or do you want the web site updated the next time you export the data and publish the web site?
Google Sites has a mechanism to import spreadsheets from Google Docs, but I don't think that's really what you want.
If you export to CSV, then there are CSV-to-HTML filters you could use. Actually, it wouldn't be hard to write one yourself if you're familiar with Perl or Python or some other scripting language.
If you export to ODS, then Open Office can export to HTML. I don't know how much you'll need to clean up the HTML for your purposes though. MS Excel can probably do the same thing, although I know the HTML produced by Microsoft software is pretty bad. HTML Tidy can be used to clean up HTML though, and is particularly tuned to clean up the bad markup produced by Microsoft products.
Feb 18 2011, 05:39 PM
Thank you for the replies, in the end someone in a phpbb forum came up with another way for us to do it and help me through it.
Thanks again, take care.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here