Slang Editorial :: Never Underestimate The Value Of A Holla'

Saturday, April 11, 2009
Creating Spreadsheet-Style Tables in Blogger

I don't know about you all, but as a numbers- and facts-loving man, I have spent years feeling frustrated over not knowing how to post spreadsheet-style tables in my blog entries. I have tried all sorts of methods and nothing has worked out in a fashion I find to be satisfactory--either strange looking, not always evenly lined up pages or ghetto-tech images. I've ultimately settled on the latter, as they at least look visually close to the table I'd like folks to see--however, anyone who cares about the numbers as much as I do should be frustrated by the fact that the fascinating numbers I've identified are uncopy-able, locked into the JPG like flies in resin. This has always left me with a very unscientific and unmath-like feeling, and therefore my hunger for real tables has stayed with me unabated.

I'm pleased to report now though that I've finally figured out the past way to post honest-to-goodness real tables into Blogger (without having any kind of HTML knowledge), as discovered by some advice by this link here. In this post, the author identifies three ways of posting tables, listing the two ways I've just identified, but also adding a third by utilizing the Spreadsheets function in Google Docs--and lo and behold it works great! (See my last post for an example).

The how-to description follows here:

Creating Table in Google Spread Sheet
Creating the table in Google’s Document, i.e., Spread Sheet, is quite easy, and moreover after publishing the table, you can just copy the code and place it in your blog’s post where you want the table to appear.

How to create table using Google Document’s Spreadsheet?

Creating the table is quite easy in Google Spread Sheet, the following things to be noted while to create the table,

Go to the blogger’s “dashboard”.
Click on “My Account” on the extreme right side.
Under “My Products”, click “DOCS”.
Now click NEW > SPREAD SHEET
The SpreadSheet is divided into Rows (number going down) and Columns (letters going across)
Now fill the information in the spread sheet and make the formatting as desired.
Save the spreadsheet by clicking, FILE > SAVE
Now publish the sheet, click Share, then > Publish as a Web Page
Select Sheet 1 Only in the next box under “What Parts”
Then at the bottom of that box, click “More Publishing Options”
In the next box that pops open, choose the HTML format: HTML embeded in a web page
“What Sheets” click “Sheet 1 Only”…again.
Now count the numbers of the table, i.e., The starting cell and the end cell in exactly diagonal fashion.
Then click “generate URL”

And now you are done to publish the post in your blog. Just copy that code into your post and hence your spread sheet/table is on your post.

I'm very geekily excited about what the future holds for me due to this new incredibly unimportant development.

Labels: BEAUMONT, case studies, curiosities, junkjunk, late arrivals, statistics

posted by Nihilist Loves Hate, Hates Everything at 4/11/2009 02:50:00 PM 0 comments

0 Comments: