Hi All
Anyone came across this problem before?
I have an X<L file created by excel
<xml id="model">
<root>
<Row>
<Cell><Data ss:Type="String">EQUATION</Data></Cell>
<Cell><Data ss:Type="String">COEFFICIENT</Data></Cell>
<Cell><Data ss:Type="String">Gllamm</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">ppi</Data></Cell>
<Cell><Data ss:Type="String">Constant</Data></Cell>
<Cell><Data ss:Type="String">0.160***</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String">(0.0054)</Data></Cell>
</Row>
</root>
And I know ingeneral how to use data islands to display the contents of the XML
in a html table and it works fine.
<table border="1" datasrc="#cdcat">
<tr>
<td><span datafld="Cell"></span></td>
</tr>
</table>
The problem with an excel created XML file is that values are all labeled "Cell"
whereas in most other regular XML, the individual values have their own label:
Cell1 and Cell2.
So my code works if each 'Row' has only one 'Cell'. But I want to use the html
code shown above repeatedly reading out each cell from a row, just as it does
read out and displays each row from the 'root' automatically.
Problem is, I cant change the XML, it machine generated and not under my control.
Thanks for any response.
Toby