gridlines toggled off when importing html table

P

photos.lang

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
 
P

Pete_UK

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
 
M

Math

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
Click to expand...

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.
 
M

Math

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.- Hide quoted text -

- Show quoted text -
Click to expand...

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:eek:="urn:schemas-microsoft-com:eek:ffice:eek:ffice"
xmlns:x="urn:schemas-microsoft-com:eek:ffice: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>
<!--table
@page{}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions><x:panes>
</x:panes></x:WorksheetOptions>
</x:ExcelWorksheet></x:ExcelWorksheets></
x:ExcelWorkbook>
</xml>
<![endif]-->
</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. :)
 

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

Similar Threads

gridlines toggled off when importing html table 0
W07: How to turn table gridlines on or off _without_ there being atable present ... 13
Getting Warning when I try to open excel in 2007. 0
Currency Symbols in custom formats when imported from HTML? 1
Can I get Excel to import XML like Access? 10
HTML converts to PLain text after viewing once 0
import html table ( which has been exported from sage line 50) 1
Importing / Linking Dynamic Data or ASP Tables into Excel ? 0

Top