gridlines toggled off when importing html table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

photos.lang@gmail.com - 23 Apr 2008 19:19 GMT

Hi,

If I create a table in html and then import it into Excel, the
gridlines are always toggled off. Does anyone know how to fix it?

I've tried saving an Excel file as html, closing it, and reopening it,
and it opens showing the girdlines.
I then ran that table through Dreamweaver's Word XML clean up. When I
opened it up, the gridlines had gone again. So that makes me assume
that there's some mso-XML code somewhere that is telling XL that it
should toggle the gridlines on. That, or it's somewhere else in the
header.

If anyone knows what I need to add to make the gridlines appear, then
I'd be able to add it to the file that formats my database output
(from an Oracle concurrent prog) as well as being extremely grateful.

As another thought, does anyone know of any guidance or lists that
explains what the standard office XML codes do - e.g. mso-ignore: mso-
background-source, etc.

Thanks again
Matt

Reply to this Message

Pete_UK - 24 Apr 2008 00:00 GMT

The gridlines often disappear when you copy/paste data from an HTML
source. I've found that the cells have borders which are coloured
white, and these overwrite the gridlines. So, highlight the offending
areas of the sheet and click on Format | Cells | Borders tab, then
click on None.

Hope this helps.

Pete

On Apr 23, 7:19 pm, photos.l...@gmail.com wrote:

> Hi,
>
[quoted text clipped - 19 lines]
> Thanks again
> Matt

Reply to this Message

Math - 24 Apr 2008 08:07 GMT

> The gridlines often disappear when you copy/paste data from an HTML
> source. I've found that the cells have borders which are coloured
[quoted text clipped - 31 lines]
> > Thanks again
> > Matt

That sort of thing was my first thought - borders, background, etc -
but it's not the case. The tick box for gridlines in the options is
empty when I open the file.

Reply to this Message

Math - 25 Apr 2008 12:38 GMT

> > The gridlines often disappear when you copy/paste data from an HTML
> > source. I've found that the cells have borders which are coloured
[quoted text clipped - 37 lines]
>
> - Show quoted text -

So far, I've managed to reinstate the grid lines by copying in some
lines from an Excel html file, into a basic file that I typed up in
Notepad (see below)

<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html;
charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<style>

</style>

</head>

<body>
<table>
<tr>
<td>1</td>
<td>2</td>
</tr>
</table>
</body></html>

But if anyone can show me a more succinct way of doing this, I'd be
very grateful. :)

Reply to this Message

Rate this thread: