Why the exported html file is not right?

J

Junjie Wang

When I save my excel worksheet into HTML and open it in my internet explorer
6.0, the display is not right. Some table border lines are missed, when I
refresh it, it seems ok. Why? I need a html file that should be with no
problem.

Thanks.

Junjie
 
D

David McRitchie

If you have a table with empty cells in your
HTML like <TD></TD> then you will be missing some lines.
When I create my HTML tables I always include &nbsp; if
typing in my own HTML. If generating from Excel with my own
macros I place an ASCII 160 character there so the cell will not
be empty. I think a plain space ASCII 32 would be still be empty.

No idea why using RELOAD would straighten things up -- that almost
sounds like a Microsoft site site with all that abominable .asp web pages.
Though I don't seem to have that problem in the last year -- perhaps I
have all the "correct" software now or just avoid MS sites because of
excessive loading times or huge footprint required for a window.

What version of Excel, what browser and version. Have you tried
your page on another browser. Is the page publicly available on
the internet. (aside from privacy issues of your data, also be
aware that Microsoft does not license Excel to place interactive
Excel worksheets as HTML on the internet, unless restricted
to only a group guaranteed to have certain software -- essentially
Microsoft Office.)

If you are using double-byte characters (used for Chinese for instance)
that might further complicate things,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top