Convert excel table to HTML

[Loïc]

Hello,

Saving an excel file as html yield an html page with a lot of useless tags.
I had component called Microsoft Office HTML Filter 2.0 with Win2000 but it
does not install with XP. Can somebody help please ?

Thankz

[David McRitchie]

Not sure but check out
The Remove Hidden Data tool for Office 2003 and Office XP
http://support.microsoft.com/kb/834427/
There were at least 15 errors noted on Woody's Watch (now Office Watch)
see my xl2html.htm page.

Since you don't want the extra tags anyway, you may be used to doing your
own HTML coding and would rather do your own conversions under your
control pasting the resulting HTML table source into your own HTML pages.
Excel to HTML conversions
http://www.mvps.org/dmcritchie/excel/xl2html.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Loïc" <[email protected]> wrote in message news:[email protected]...
> Hello,
>
> Saving an excel file as html yield an html page with a lot of useless tags.
> I had component called Microsoft Office HTML Filter 2.0 with Win2000 but it
> does not install with XP. Can somebody help please ?
>
> Thankz

[Loïc]

Sorry but I use xls for texts data only and the macro seems to be 2
complicate for me, I am surprised that microsoft office does not deliver pure
html .... I am going to use and old pc of mine with win2000 and the filter !!!

"David McRitchie" wrote:

> Not sure but check out
> The Remove Hidden Data tool for Office 2003 and Office XP
> http://support.microsoft.com/kb/834427/
> There were at least 15 errors noted on Woody's Watch (now Office Watch)
> see my xl2html.htm page.
>
> Since you don't want the extra tags anyway, you may be used to doing your
> own HTML coding and would rather do your own conversions under your
> control pasting the resulting HTML table source into your own HTML pages.
> Excel to HTML conversions
> http://www.mvps.org/dmcritchie/excel/xl2html.htm
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Loïc" <[email protected]> wrote in message news:[email protected]...
> > Hello,
> >
> > Saving an excel file as html yield an html page with a lot of useless tags.
> > I had component called Microsoft Office HTML Filter 2.0 with Win2000 but it
> > does not install with XP. Can somebody help please ?
> >
> > Thankz
>
>
>

[Loïc]

The macro xl2html works just perfectly, thanks so much for the tîp !

Loïc

"David McRitchie" wrote:

> Not sure but check out
> The Remove Hidden Data tool for Office 2003 and Office XP
> http://support.microsoft.com/kb/834427/
> There were at least 15 errors noted on Woody's Watch (now Office Watch)
> see my xl2html.htm page.
>
> Since you don't want the extra tags anyway, you may be used to doing your
> own HTML coding and would rather do your own conversions under your
> control pasting the resulting HTML table source into your own HTML pages.
> Excel to HTML conversions
> http://www.mvps.org/dmcritchie/excel/xl2html.htm
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Loïc" <[email protected]> wrote in message news:[email protected]...
> > Hello,
> >
> > Saving an excel file as html yield an html page with a lot of useless tags.
> > I had component called Microsoft Office HTML Filter 2.0 with Win2000 but it
> > does not install with XP. Can somebody help please ?
> >
> > Thankz
>
>
>

[David McRitchie]

You're welcome, thought I'd heard from two different people.
Was this the first time you'd used macros.

I think Microsoft at least recognizes that people don't necessarily
want round tripping code in their generated HTML out of an application
and want small code instead of bloated code. Then again since it sounds like
XML will be generated from Excel it doesn't sound like the files will be small.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Loïc" <[email protected]> wrote in message news:[email protected]...
> The macro xl2html works just perfectly, thanks so much for the tîp !
>
> Loïc
>
> "David McRitchie" wrote:
>
> > Not sure but check out
> > The Remove Hidden Data tool for Office 2003 and Office XP
> > http://support.microsoft.com/kb/834427/
> > There were at least 15 errors noted on Woody's Watch (now Office Watch)
> > see my xl2html.htm page.
> >
> > Since you don't want the extra tags anyway, you may be used to doing your
> > own HTML coding and would rather do your own conversions under your
> > control pasting the resulting HTML table source into your own HTML pages.
> > Excel to HTML conversions
> > http://www.mvps.org/dmcritchie/excel/xl2html.htm
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
> > "Loïc" <[email protected]> wrote in message news:[email protected]...
> > > Hello,
> > >
> > > Saving an excel file as html yield an html page with a lot of useless tags.
> > > I had component called Microsoft Office HTML Filter 2.0 with Win2000 but it
> > > does not install with XP. Can somebody help please ?
> > >
> > > Thankz
> >
> >
> >