Import Excel table as html table

E

ezrecall

What is the best way to convert an Excel table (text, no formulas) to html
and get it clean -- certainly no MSO tags, for instance?
 
S

Steve Easton

with it open in Excel, click File > "Save As" and select html from the
list.

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer
 
S

Stefan B Rusynko

Unfortunately that will include all the MSO roundtripping formatting & print media based styles
- the only way I have been able to do it as clean html is w/ some custom VBA code to write the tags


_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


| with it open in Excel, click File > "Save As" and select html from the
| list.
|
| --
| Steve Easton
| Microsoft MVP FrontPage
| 95isalive
| This site is best viewed............
| .......................with a computer
|
| | > What is the best way to convert an Excel table (text, no formulas) to
| html
| > and get it clean -- certainly no MSO tags, for instance?
|
|
 
S

Stefan B Rusynko

Yes but it only supports and can be installed with MSO 2000




| Microsoft has a program you can download to strip out the MSO junk:
| http://www.microsoft.com/downloads/...ee-3fbd-482c-83b0-96fb79b74ded&displaylang=en
|
| You save the worksheet (or Word document, or whatever) as html, and then run
| the html file through the above program. It's worked pretty well for me.
|
| ...Brenda
|
| | > Unfortunately that will include all the MSO roundtripping formatting &
| > print media based styles
| > - the only way I have been able to do it as clean html is w/ some custom
| > VBA code to write the tags
| >
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | > | with it open in Excel, click File > "Save As" and select html from the
| > | list.
| > |
| > | --
| > | Steve Easton
| > | Microsoft MVP FrontPage
| > | 95isalive
| > | This site is best viewed............
| > | .......................with a computer
| > |
| > | | > | > What is the best way to convert an Excel table (text, no formulas) to
| > | html
| > | > and get it clean -- certainly no MSO tags, for instance?
| > |
| > |
| >
| >
|
|
 
Top