« How People Found Me – November Edition | Main | The Imus Chronicles »
Excel Macro to Create Table HTML
By Brian | December 2, 2007 | Share on Facebook
Way back in August of 2006, I posted on how to make HTML tables appear properly in Blogger posts. Since then, whenever I needed one, I’d write out the code in a text editor, get it just like I wanted it, and remove all the line breaks and paste the resulting (cryptic) code in my post.
It occurred to me recently that Excel should be able to do this for me. I tried the “Save As HTML” feature, but the HTML code it generates is exceedingly difficult to read. It’s not that it’s incorrect, mind you, it’s just that it includes individual style elements for each cell, so the resulting HTML is very flexible, but also very difficult to read.
To address this problem, I’ve written a quick Visual Basic macro that creates simple HTML code, like most people use for quick and dirty tables in blogposts.
Here’s what you need to do:
|
Topics: Tech Talk | Comments Off on Excel Macro to Create Table HTML Comments are closed. |