Log in

No account? Create an account
Top Tip - Many a mickle maks a muckle

> Recent Entries
> Archive
> Friends
> Profile

August 7th, 2003

Previous Entry Share Next Entry
11:01 pm - Top Tip
Suppose you have a table in Excel that you would like to convert into raw HTML, but raw HTML that you would actually dare include in a web page as opposed to Microsoft HTML with loads of stylistic padding and other useless junk. Simply save your table as a HTML file, then load the file into a text editor. Perform a search and replace, searching for the regular expression <tr[^>]*> and replacing it with <tr> - ditto for the td tags. Result: a very ordinary table which you can style or leave unstyled as you like.

No punchline.
Current Mood: iffy, but at least working
Current Music: NiGHTS Good NiGHT OC ReMix (sort of gentle ambient stuff)

(4 comments | Leave a comment)


[User Picture]
Date:August 7th, 2003 04:29 pm (UTC)
I would copy the table in Excel, then paste on a Word doc and save it there as HTML. In fact, I've done it before -- when I ranked the Game Shows '75 sites monthly by how many hits each show/page got, for example.
[User Picture]
Date:August 7th, 2003 04:38 pm (UTC)
Very nice! I hate the clunkiness of Microsoft html.
[User Picture]
Date:August 7th, 2003 09:17 pm (UTC)
Oh, if only it did the same in Quattro Pro. :\
[User Picture]
Date:August 8th, 2003 02:13 am (UTC)
That is useful. *files away FFR*

> Go to Top