I have discovered that in Google Spreadsheet, there is also an option to embed a spreadsheet into your website. I am testing it now:
Well, it worked. The way to do this is to go to Welcome to Google Docs & Spreadsheets!, start a Google account if you don't have one already, then make your spreadsheet. When your spreadsheet is ready, the "PUBLISH" tab at the top right-hand corner of the page, select which part of the spreadsheet you want published (in my case, it was sheet 1 only). You can even choose whether you want the spreadsheet to be updated automatically (every 5 minutes) or updated manually.
Then click on "MORE PUBLISHING OPTIONS" at the bottom of the pop-up.
Then under drop-down menu "FILE FORMAT", click the down arrow and select "HTML TO EMBED IN A WEBPAGE". Put in the range of the cells you want to include in the spreadsheet (in my case, it was A1:C4), click "GENERATE URL" and the script to paste into your post editor window will be generated.
7 comments:
Hi, how did you remove the published via Google Docs & Spreadsheets - updated automatically every 5 minutes
title. Can't seem to fgure that out.
Hi Rex,
To tell you the truth, I hardly do tables, and I was just doing it for the test, and I can't remember all that I did. Whatever I did had been described in the post. Maybe something changed between the time I did the test and now. Maybe Google decided to add that "Published via ..." thing in recently. I don't know.
Maybe I will test again and see what happen
Peter a.k.a. Enviroman
Enviroman Says
Hi Rex,
Tested embedding Google spreadsheet again according to what had been described in this post. See post Testing embedding Google spreadsheet in New Blogger (formerly beta) again.
This spreadsheet is currently not working.
Hey, thanks for posting this - I have been struggling with how to make this work for 2 days now.
Top advice I did this and it looks great. here it is.
http://trade-invest-win.blogspot.com/2009/02/4-stock-screeners-pt-1-finding-needles.html
thanks a lot
Post a Comment