Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Location
    Victoria, Australia
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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 <img src=/S/aussie.gif border=0 alt=aussie width=21 height=22>

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    Since you already discovered the <img src=/S/barf.gif border=0 alt=barf width=64 height=23> HTML code generated and have vowed to not continue to do this anymore <img src=/S/duck.gif border=0 alt=duck width=23 height=23> , 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 <img src=/S/puke.gif border=0 alt=puke width=60 height=15> 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 <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20>

    Deb

  4. #4
    New Lounger
    Join Date
    Sep 2002
    Location
    Victoria, Australia
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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 <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18> <img src=/S/flags/NewZealand.gif border=0 alt=NewZealand width=30 height=18>

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    The link I gave you for HTML Maker appears outdated and redirects. Try http://www.interq.or.jp/sun/puremis/colo/HtmlMakerD.htm. 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 <img src=/S/grin.gif border=0 alt=grin width=15 height=15>. If you still have trouble, just yell and I'll try to hunt some down.

    Alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •