HTML and csv problem

[Megan]

When I create a or convert to a .csv format, the html in
the file is rendered as if Excel is a browser ie.
displays the images. It also spreads the HTML, which I'd
like to remain in one cell, across several cells.

I don't have this problem using Excel on my Mac. Only
Excel on my PC's?

I need to keep the cell formatting and for the the html
to be like text. How?

Thanks!

 

[Megan]

I realize know it's specifically the <table> tags that
ruin the conversion. Other html like <img src> are fine
until there in the same file with any <table> tags in it.
Then the cells loose their formatting and the images
render as if Excel were a browser. Is there a way to turn
off Excel recognizing the <table> tags as something it
has to display?

TIA again

 

[David McRitchie]

Hi Megan,
If you want to generate your own HTML see my webpage.
http://www.mvps.org/dmcritchie/excel/xl2html.htm

Other than that I don't know of any way. You will note that
the generated file will be much much smaller than an HTML
file generated with Save As, but if you want all the other
bells and whistles you won't get them.

I use it to generate my tables and stick them as individual
examples within my HTML pages. But you can see that you
could generate whatever you want.