Excel to HTML: Stripping excess html code (XP or 2000)

Topic

New Reply

A sports club updates league points in Excel and sends the Excel file to me for posting to our web site. I use Excel’s ‘Save as Web Page’ to produce an HTML file. But as the year progresses so does the size of the HTML file. The 83KB Excel file now produces an HTML file over 500KB. That is unacceptable for members with dial-up.

Does anyone know of utility software that will strip excess HTML code? I am sure this could be an easy answer as I have previously read that MS products produce excessive HTML code.

Else I will have to engage in laborious file splitting etc.

Thanks, Ken

Reply | Quote

Replies

You might want to try the Html Maker addin, which I believe produces HTML without the XML markup. This is not “excess HTML code” BTW. It’s used/ introduced so that the exported file can be used in both Excel and other Office products. It’s often mistakenly referred to as excess baggage by those who only know about HTML as a markup for web browsers, and hence “accuse” MS as producing bloated code.

Alan

Reply | Quote

Since you already discovered the HTML code generated and have vowed to not continue to do this anymore , I suggest a google search for ‘html clean’. I found quite a few tools that sound like they’d work well. One at the top of the hit list is for Word but I’d think it’d work for Excel as they both at writing HTML. Also the good ol’ HTML Tidy is also a nice tool. It’s there in the google search as well.

Have fun with this laborious task

Deb

Reply | Quote

Thanks Alan and Deb. Those products look promising but alas appear to be only for UNIX platforms. I will keep searching as you suggest as I am sure there must be WIN products too.

Regards, Ken

Reply | Quote

The link I gave you for HTML Maker appears outdated and redirects. Try http://www.interq.or.jp/sun/puremis/colo/HtmlMakerD.htm%5B/url%5D. This certainly works on Windows platforms too. I know there are other 3rd party freeware applications to do this, because I’ve tried them out . If you still have trouble, just yell and I’ll try to hunt some down.

Alan

Reply | Quote