Importing nested tables from HTML to Excel

B

bhartman36

Hi, Everyone.

I've got something like the following table:

<table>
<th bgcolor="green">First Row</th><th bgcolor="green">Second Row</
th><th bgcolor="green">Third Row</th><th bgcolor="green">Fourth Row</
th>
<tr>
<td>A test again</td>
<td>Yet another Test.</td>
<td>How many tests can I possibly do? Enquiring minds really really
really really really really really really really really want to know!</
td>
<td rowspan="1" style="white-space:nowrap"><pre>
Text,
More text,
Blah,
More text,
Some More Text,
Yet Again Text,
One More Time!</pre>
</td>
</tr>
<tr>
<td>This is a test of how much crap I can put in here and how much it
will wrap. I don't know what the answer is. How about you? I'm
really hoping this does well..</td>
<td>This is another test. I'm writing as much as I can in here. It's
really tough to do, though!</td>
<td>This is a third test Let me see if I can think of more things to
write here. I don't know if this will work!</td>
<td>This is some more godforesaken text!</td>
</tr>
</table>
The table works fine in IE or Firefox, but Excel insists on making
each of the TDs separate rows. What I'm trying to do is have
everything show up in one cell, but to keep the breaks so that it's a
list. Is there a way to do this? When it gets to "Test", "More
text", etc., I want that all in one cell, but listed just like it is
in the code, instead of w/o the breaks. Is that possible?

I'm using Excel 2007. Thanks!
 

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