Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Loïc
 
Posts: n/a
Default Convert excel table to HTML

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
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default Convert excel table to HTML

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" wrote in message ...
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



  #3   Report Post  
Loïc
 
Posts: n/a
Default Convert excel table to HTML

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" wrote in message ...
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




  #4   Report Post  
Loïc
 
Posts: n/a
Default Convert excel table to HTML

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" wrote in message ...
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




  #5   Report Post  
David McRitchie
 
Posts: n/a
Default Convert excel table to HTML

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" wrote in message ...
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" wrote in message ...
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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting HTML table with feet/inches column, excel changes it to da Bothell John Excel Discussion (Misc queries) 0 September 6th 05 06:40 AM
Problem with linked Excel table in a word Document jcarlos Excel Discussion (Misc queries) 1 August 5th 05 07:41 PM
Adjust an Excel table with the width of a Word page [email protected] Excel Discussion (Misc queries) 1 August 2nd 05 10:24 AM
paste excel table to word Stephen Excel Worksheet Functions 1 January 23rd 05 03:27 PM
Paste table from excel to word Stephen Excel Worksheet Functions 0 January 22nd 05 11:15 AM


All times are GMT +1. The time now is 05:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"