B
Bernhard
Hi,
I am trying to import data from a web page (table) to
Excel 97. The data should be displayed in the same Web
browser window or Excel should be opened. The table to be
displayed in Excel contains long product numbers which
without special formatting would be transformed to
scientific format.
The formatting is done by using style='vnd.ms-
excel.numberformat
' when generating the output.
This works fine using Office 2000 or Office XP. Using
Excel 97 does not take into consideration the formatting.
Is there an other way to get around this problem?
Does Excel 97 support something similar to style='vnd.ms-
excel.numberformat'?
Thanks
Bernhard
I tested with a html file containing the following to
simulate the dynamically generated web page:
<html>
<head>
<title></title>
</head>
<body>
<table cellpadding="0" cellspacing="0" border="0"
width="100%">
<tr>
<td align="right" class="pagelogoright"
nowrap>Shipment</td>
</tr>
</table>
<table><tr>
<th>Col1
<th>Col2
<th>Col3
</tr>
<tr>
<td style='vnd.ms-
excel.numberformat'>0123456789012345678901234567890123456
789</td>
<td>X900001</td>
<td>78</td>
</tr>
<tr>
<td>0123456789012345678901234567890123456789</td>
<td>X900001</td>
<td>X900001</td>
</tr>
</table>
I am trying to import data from a web page (table) to
Excel 97. The data should be displayed in the same Web
browser window or Excel should be opened. The table to be
displayed in Excel contains long product numbers which
without special formatting would be transformed to
scientific format.
The formatting is done by using style='vnd.ms-
excel.numberformat
' when generating the output.This works fine using Office 2000 or Office XP. Using
Excel 97 does not take into consideration the formatting.
Is there an other way to get around this problem?
Does Excel 97 support something similar to style='vnd.ms-
excel.numberformat
'?Thanks
Bernhard
I tested with a html file containing the following to
simulate the dynamically generated web page:
<html>
<head>
<title></title>
</head>
<body>
<table cellpadding="0" cellspacing="0" border="0"
width="100%">
<tr>
<td align="right" class="pagelogoright"
nowrap>Shipment</td>
</tr>
</table>
<table><tr>
<th>Col1
<th>Col2
<th>Col3
</tr>
<tr>
<td style='vnd.ms-
excel.numberformat
'>0123456789012345678901234567890123456789</td>
<td>X900001</td>
<td>78</td>
</tr>
<tr>
<td>0123456789012345678901234567890123456789</td>
<td>X900001</td>
<td>X900001</td>
</tr>
</table>