Open HTML in Excel

  • Thread starter Thread starter warren.wang
  • Start date Start date
W

warren.wang

when opening the following html in Excel, the first <td> actully
was converted into 3 excel cell. is there any way I can force them into
one cell? so that each <td> got converted exactly into one cell no
matter what html text inside <td>



<table>
<tr>
<td >
Column 1
<li>
item #1
<li>
item #2
</td>
<td >
Column 2
</td >
</tr>
</table>
 
(e-mail address removed) shared this with us in microsoft.public.excel.misc:
when opening the following html in Excel, the first <td> actully
was converted into 3 excel cell. is there any way I can force them
into one cell? so that each <td> got converted exactly into one cell
no matter what html text inside <td>



<table>
<tr>
<td >
Column 1
<li>
item #1
<li>
item #2
</td>
<td >
Column 2
</td >
</tr>
</table>
Click to expand...

No, you can't.
Because the <li> is a paragraph-type element.
Anyway your HTML is totally invalid. <li> needs a <ul> or <ol>
container, and also a closing </li> tag:

<table>
<tr>
<td>
Column 1
<ul>
<li>item #1</li>
<li>item #2</li>
</ul>
</td>
<td>
Column 2
</td>
</tr>
</table>

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way

How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoynePollard/FGA/questions-with-yes-or-n
o-answers.html
 
Back
Top