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

 

[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 !!!

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

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

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

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

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

Loïc

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

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