Embedding a Google Spreadsheet
If you have a Gmail account, you really need to take a look around at all of the features that Google makes available for free. They're rich in features and there's so much that you can do. It may well be your one stop for all applications
Take a look below. That isn't a table in this webpage. It's actually a spreadsheet that I've posted on a Google Spreadsheet. It is embedded into this webpage.
The data represents the top pages on the GEC Computers in the Classroom website and the number of hits that it has received since September 1.
So, I log into my Google account. I've got it on my "iGoogle" page which we've already seen can be a terrific way to organize your starting points. So, you create your spreadsheet. When it's time to make it available to others, we're going to select the Publish option in the top right corner of the spreadsheet.
Now, that's great and I could give that URL to anyone who I'd like to have access to the spreadsheet. But, it gets better. At the bottom of this dialogue, notice that there are "More Publishing Options".
I really want to check this out because I don't just want my spreadsheet to be viewable by others; I want it to be INSIDE another web page. For example, you may have some data that you would like to share with your students. Checking out this link reveals exactly what we need.
I want to generate HTML to embed the spreadsheet into a page and I'd like to only show you part of the spreadsheet. (Doesn't that make you wonder what else is there?)
We need to click into the code above and copy it all. Now, back we go to Dreamweaver and place your cursor exactly where in your web page you'd like to place the spreadsheet.
Switch from Design View to Code View. You can read all the lovely HTML that you've generated but if you don't care and just want the spreadsheet, do a simple paste option and you add more code to the page.
Switch back to Design View and finish off any work that you have for the web page and publish it to your server. When you or anyone else happens to hit that page, the portion of the spreadsheet that you've identified appears in its proper spot in your webpage.
Do it a couple times and you'll find that it's the easiest and quickest way to share your spreadsheet with others..
