ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Html in Excel (https://www.excelbanter.com/excel-programming/280352-html-excel.html)

TOM

Html in Excel
 
Hello All,

Below is my html file, which I got using saveas(
htmltable!) html file is like what I want but if I will
open it in Excel I will not get backcolor and all
formatting it shows in Html.

So please tell me how I can achieve this ?




<title</title
<STYLE TYPE="text/css"
<!--
..htmldwC5B{;background-color:#ffffff; width:100%}
..htmldwC5D{}
..htmldwC5E{;background-color:#ffffff;
width:100%;COLOR:#000000;FONT:12pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:bold;TEXT-
DECORATION:none;TEXT-ALIGN:left;BORDER-STYLE:solid}
..htmldwC5F{;background-color:#d4d0c8;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:left;BORDER-STYLE:solid}
..htmldwC60{;background-color:#fffacd;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:left;BORDER-STYLE:solid}
..htmldwC65{;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:left;BORDER-STYLE:solid}
..htmldwC6D{;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:center;BORDER-STYLE:solid}
..htmldwC79{;background-color:#fffacd;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:center;BORDER-STYLE:solid}
..htmldwC7F{;background-color:#fffacd;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:right;BORDER-STYLE:solid}
..htmldwC84{;background-color:#ffdab9;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:left;BORDER-STYLE:solid}
..htmldwC85{;background-color:#ffdab9;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:center;BORDER-STYLE:solid}
..htmldwC8B{;background-color:#ffdab9;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:right;BORDER-STYLE:solid}
..htmldwC90{;background-color:#d4d0c8;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:bold;TEXT-
DECORATION:none;TEXT-ALIGN:center;BORDER-STYLE:solid}
..htmldwC92{;background-color:#d4d0c8;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:bold;TEXT-
DECORATION:none;TEXT-ALIGN:right;BORDER-STYLE:solid}
--
</STYLE

<TABLE CLASS=htmldwC5B BORDER=1 WIDTH=693

<TR<TD NOWRAP WIDTH=88<TD NOWRAP WIDTH=11<TD NOWRAP
WIDTH=22<TD NOWRAP WIDTH=22<TD NOWRAP WIDTH=33<TD
NOWRAP WIDTH=33<TD NOWRAP WIDTH=66<TD NOWRAP
WIDTH=77<TD NOWRAP WIDTH=22<TD NOWRAP WIDTH=22<TD
NOWRAP WIDTH=77<TD NOWRAP WIDTH=88<TD NOWRAP
WIDTH=55<TD NOWRAP WIDTH=66<TD NOWRAP WIDTH=11</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC5E COLSPAN=9ROSIBLU COST
SHEET (INTERNAL DOCUMENT)</TD








<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC5FCollection</TD
<TD NOWRAP CLASS=htmldwC60 COLSPAN=42700-2899WRAP</TD



</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC5FStyle #</TD
<TD NOWRAP CLASS=htmldwC60 COLSPAN=4HARISSH</TD



</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC5FDescription</TD
<TD NOWRAP CLASS=htmldwC60 COLSPAN=4Harish Test
Style</TD



</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC65Finished DWT</TD
<TD NOWRAP CLASS=htmldwC60 COLSPAN=44.0000</TD



</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC65Production</TD
<TD NOWRAP CLASS=htmldwC60 COLSPAN=4D</TD



</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=2Components</TD

<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=4Casting/Metal</TD



<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=2Casting # /
Metal</TD

<TD NOWRAP CLASS=htmldwC6D ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65Metal</TD
<TD NOWRAP CLASS=htmldwC65Dwt.</TD
<TD NOWRAP CLASS=htmldwC65Vendor</TD
<TD NOWRAP CLASS=htmldwC6D ALIGN=center
COLSPAN=2Qty.</TD

<TD NOWRAP CLASS=htmldwC65Metal Cost/Dwt.</TD
<TD NOWRAP CLASS=htmldwC65Casting Cost</TD
<TD NOWRAP CLASS=htmldwC65Labor Cost</TD
<TD NOWRAP CLASS=htmldwC65Total Cost</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC60 COLSPAN=210056TCST</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center10KT</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center1.4000</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center
COLSPAN=21.0</TD

<TD NOWRAP CLASS=htmldwC7F ALIGN=right10.21</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right23.74</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right12.00</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right35.74</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC84 COLSPAN=210056TCST</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center10KT</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center1.3000</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center
COLSPAN=21.0</TD

<TD NOWRAP CLASS=htmldwC8B ALIGN=right9.48</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right23.74</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right12.00</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right35.74</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=centerTotal ct.</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=center
COLSPAN=22</TD

<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right47.48</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right71.48</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=4Stones</TD



<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=2Stone Type</TD

<TD NOWRAP CLASS=htmldwC6D ALIGN=center
COLSPAN=2Shape</TD

<TD NOWRAP CLASS=htmldwC65Cut</TD
<TD NOWRAP CLASS=htmldwC65Size</TD
<TD NOWRAP CLASS=htmldwC65Clr./Qlty.</TD
<TD NOWRAP CLASS=htmldwC65Vendor</TD
<TD NOWRAP CLASS=htmldwC6D ALIGN=center
COLSPAN=2Qty.</TD

<TD NOWRAP CLASS=htmldwC65Stone Cost/Ct</TD
<TD NOWRAP CLASS=htmldwC65Total Gem Cst</TD
<TD NOWRAP CLASS=htmldwC65Setting Cost</TD
<TD NOWRAP CLASS=htmldwC65Ttl Setting Cst</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC60 COLSPAN=2DIAM</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center
COLSPAN=2EM</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center.22</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=centerIF/NA</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center
COLSPAN=22.0</TD

<TD NOWRAP CLASS=htmldwC7F ALIGN=right694.95</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right2779.80</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right9.00</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right2788.80</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC84 COLSPAN=2CRRB</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center
COLSPAN=2BEAD</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center0.0100</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=centerCLAR/NA</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center
COLSPAN=21.0</TD

<TD NOWRAP CLASS=htmldwC8B ALIGN=right2.00</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right2779.80</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right9.00</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right2788.80</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=centerTotal ct.</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=center
COLSPAN=23</TD

<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right5559.6</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right5577.6</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=4Finding</TD



<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=2Finding
Desc./Style #</TD

<TD NOWRAP CLASS=htmldwC6D ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC65Metal</TD
<TD NOWRAP CLASS=htmldwC65Dwt.</TD
<TD NOWRAP CLASS=htmldwC65Size</TD
<TD NOWRAP CLASS=htmldwC65Vendor</TD
<TD NOWRAP CLASS=htmldwC6D ALIGN=center
COLSPAN=2Qty.</TD

<TD NOWRAP CLASS=htmldwC65Component Cost</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65Misc. Cost</TD
<TD NOWRAP CLASS=htmldwC65Total Cost</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC60 COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center
COLSPAN=20</TD

<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=centerTotal ct.</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=center
COLSPAN=20</TD

<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right0</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=4Production</TD



<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=2Prod. Steps</TD

<TD NOWRAP CLASS=htmldwC6D ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC65Vendor/Contractor</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65Req. of Vendor</TD
<TD NOWRAP CLASS=htmldwC6D ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65Total Cost</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC84 COLSPAN=2Assembly</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center
COLSPAN=20</TD

<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC60 COLSPAN=2Polishing</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center
COLSPAN=20</TD

<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC84 COLSPAN=2Final
Finishing</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center
COLSPAN=20</TD

<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC60 COLSPAN=2Packaging</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center
COLSPAN=20</TD

<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC84 COLSPAN=2Shipping</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center
COLSPAN=20</TD

<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=centerTotal ct.</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=center COLSPAN=2</TD

<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=4For Finished
Goods</TD



<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=2Style #</TD

<TD NOWRAP CLASS=htmldwC6D ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC65Vendor Order Style #</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65Vendor</TD
<TD NOWRAP CLASS=htmldwC6D ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65Total Cost</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC60 COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center
COLSPAN=20</TD

<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=centerTotal ct.</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=center COLSPAN=2</TD

<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=3Notes : General
Instruction</TD


<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC60 COLSPAN=14Special
Instructions</TD













<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65Gemstone PO date :</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC65Ttl Gem Cost</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC65Ttl Mfg Cost</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC65Protect. M/U %</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center0</TD
<TD NOWRAP CLASS=htmldwC65RBF Prot'd</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC65Wh.sale M/U %</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center0</TD
<TD NOWRAP CLASS=htmldwC65Wholesale</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC65Retail M/U %</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center0</TD
<TD NOWRAP CLASS=htmldwC65MSRP</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
</TABLE


Paul Robinson

Html in Excel
 
Hi Tom,
Your message is far too long for anyone to look through - give a
shorter version??
Also, can't you just open the original Excel file? Why save excel as
HTML then open the HTML in Excel??!
regards
Paul

"TOM" wrote in message ...
Hello All,

Below is my html file, which I got using saveas(
htmltable!) html file is like what I want but if I will
open it in Excel I will not get backcolor and all
formatting it shows in Html.

So please tell me how I can achieve this ?



All times are GMT +1. The time now is 11:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com