I am using Excel 2007.

I have 5 columns as illustrated below - (Table Description has no rows yet)

CTwt. Size Metal Jewelers cost Table Description

5 10 Tungsten 31
4 10.5 Tungsten 35
2 11 Tungsten 50
10 11.5 Tungsten 20
8 12 Tungsten 15
5 12.5 Tungsten 50
6 13 Tungsten 45

I need to create html table code for hundreds of products similar to above.

(The html table code below is from a different product than the 5 columned
format example above)

(This html table code is from a different product than the 5 columned
example above)

<DIV class="ProductDetailsTabs"
<table style="WIDTH: 350px; BORDER-COLLAPSE: collapse"
<tbody
<tr
<td class="SpecTableTitle" colspan="2"Product Details</td
</tr
<tr
<td class="SpecTableCell"Metal:</td
<td class="SpecTableCell"Polished Tungsten</td
</tr
<tr
<td class="SpecTableCell"Clasp:</td
<td class="SpecTableCell"Fancy Lobster</td
</tr
<tr
<td class="SpecTableCell"Length:</td
<td class="SpecTableCell"9.5 inches</td
</tr
</tbody
</table

How do I get this accomplished?

Thank you for your help.

This doesn't seem much like an Excel Question as it is an HTML question. Be
that as it may, the HTML for your table would look like this:

<table COMMENT: This starts the Table
<tr COMMENT: This starts the first row
<tdCTwt.</td COMMENT: This is the first column in the first row
<tdSize</td
<tdMetal</td
<tdJewelers cost</td
<tdTable Description</td
</tr
<tr
<td5</td
<td10</td
<tdTungsten</td
<td31</td
<td</td
</tr
....

This process is completed for each row. Be sure each row has 5 <td and
</td statements with the cell's content between.
End the code group with </table to close the table.

There are also settings you can include inside the tags (i.e. <table, <tr,
and <td) which can set the alignment of the text and the type of border on
the table. Doing a search on HTML Tables will no doubt yield many results.

Depending on what you're using to edit the HTML document, you may be able to
copy and paste the table from Excel into he document (i.e. if it is a WYSIWYG
editor like FrontPage) or you may be able to create a table in the editor and
just enter the information (again, it would have to be a WYSIWYG editor most
likely).

Allen.

"urlocaljeweler" wrote:

I am using Excel 2007.

I have 5 columns as illustrated below - (Table Description has no rows yet)

CTwt. Size Metal Jewelers cost Table Description

5 10 Tungsten 31
4 10.5 Tungsten 35
2 11 Tungsten 50
10 11.5 Tungsten 20
8 12 Tungsten 15
5 12.5 Tungsten 50
6 13 Tungsten 45

I need to create html table code for hundreds of products similar to above.

(The html table code below is from a different product than the 5 columned
format example above)

(This html table code is from a different product than the 5 columned
example above)

<DIV class="ProductDetailsTabs"
<table style="WIDTH: 350px; BORDER-COLLAPSE: collapse"
<tbody
<tr
<td class="SpecTableTitle" colspan="2"Product Details</td
</tr
<tr
<td class="SpecTableCell"Metal:</td
<td class="SpecTableCell"Polished Tungsten</td
</tr
<tr
<td class="SpecTableCell"Clasp:</td
<td class="SpecTableCell"Fancy Lobster</td
</tr
<tr
<td class="SpecTableCell"Length:</td
<td class="SpecTableCell"9.5 inches</td
</tr
</tbody
</table

How do I get this accomplished?

Thank you for your help.

I saw your other post about splitting that 5th column into a table on it's
own. That can also be done in html. You can do it a couple ways. The
first, and probably easier but messier, way is to put a <table element as
the contents of the desired cell. Then you can have <tr for your rows
within that table and <td for the columns within the rows. i would STRONGLY
suggest the formatting of the HTML as i had below with successive tabs when
you open a new tag to help keep things organized. The second, a little more
pre-thought-out but more correct way, would involve using <tr rowspan=4 to
span multiple rows (for all cells in columns 1-4) and <td colspan=3 to span
multiple columns (which you would only need for the header row's column 5 if
all other column 5 cells are tables).

"Allen" wrote:

This doesn't seem much like an Excel Question as it is an HTML question. Be
that as it may, the HTML for your table would look like this:

<table COMMENT: This starts the Table
<tr COMMENT: This starts the first row
<tdCTwt.</td COMMENT: This is the first column in the first row
<tdSize</td
<tdMetal</td
<tdJewelers cost</td
<tdTable Description</td
</tr
<tr
<td5</td
<td10</td
<tdTungsten</td
<td31</td
<td</td
</tr
...

This process is completed for each row. Be sure each row has 5 <td and
</td statements with the cell's content between.
End the code group with </table to close the table.

There are also settings you can include inside the tags (i.e. <table, <tr,
and <td) which can set the alignment of the text and the type of border on
the table. Doing a search on HTML Tables will no doubt yield many results.

Depending on what you're using to edit the HTML document, you may be able to
copy and paste the table from Excel into he document (i.e. if it is a WYSIWYG
editor like FrontPage) or you may be able to create a table in the editor and
just enter the information (again, it would have to be a WYSIWYG editor most
likely).

Allen.

"urlocaljeweler" wrote:

I am using Excel 2007.

I have 5 columns as illustrated below - (Table Description has no rows yet)

CTwt. Size Metal Jewelers cost Table Description

5 10 Tungsten 31
4 10.5 Tungsten 35
2 11 Tungsten 50
10 11.5 Tungsten 20
8 12 Tungsten 15
5 12.5 Tungsten 50
6 13 Tungsten 45

I need to create html table code for hundreds of products similar to above.

(The html table code below is from a different product than the 5 columned
format example above)

(This html table code is from a different product than the 5 columned
example above)

<DIV class="ProductDetailsTabs"
<table style="WIDTH: 350px; BORDER-COLLAPSE: collapse"
<tbody
<tr
<td class="SpecTableTitle" colspan="2"Product Details</td
</tr
<tr
<td class="SpecTableCell"Metal:</td
<td class="SpecTableCell"Polished Tungsten</td
</tr
<tr
<td class="SpecTableCell"Clasp:</td
<td class="SpecTableCell"Fancy Lobster</td
</tr
<tr
<td class="SpecTableCell"Length:</td
<td class="SpecTableCell"9.5 inches</td
</tr
</tbody
</table

How do I get this accomplished?

Thank you for your help.