I have an xml file that uses xmlss. I can extract the information with no
problem, however is there a wildcard in an xpath expression I can use so
that I don't have to type in the specific index for every line. I need to be
able to pull the data for each "Row" node, IE..<Row ss:Index=*>, and
everything in between. Help!! Thanks in advance
Example:
- <Row ss:Index="7">
- <Cell ss:Index="1">
<Data ss:Type="String">NET PAY</Data>
</Cell>
- <Cell ss:Index="2">
<Data ss:Type="String">NET PAY</Data>
</Cell>
- <Cell ss:Index="3">
<Data ss:Type="String">1000</Data>
</Cell>
- <Cell ss:Index="5" ss:StyleID="s22">
<Data ss:Type="Number">15,392.70</Data>
</Cell>
- <Cell ss:Index="6">
<Data ss:Type="Number">0000</Data>
</Cell>
- <Cell ss:Index="7">
<Data ss:Type="Number">000000</Data>
</Cell>
</Row>
- <Row ss:Index="8">
- <Cell ss:Index="1">
<Data ss:Type="String">FEDERAL W/H</Data>
</Cell>
- <Cell ss:Index="2">
<Data ss:Type="String">FEDERAL W/H</Data>
</Cell>
- <Cell ss:Index="3">
<Data ss:Type="String">1200</Data>
</Cell>
- <Cell ss:Index="5" ss:StyleID="s22">
<Data ss:Type="Number">1,764.16</Data>
</Cell>
- <Cell ss:Index="6">
<Data ss:Type="Number">0000</Data>
</Cell>
- <Cell ss:Index="7">
<Data ss:Type="Number">000000</Data>
</Cell>
</Row>
- <Row ss:Index="9">
- <Cell ss:Index="1">
<Data ss:Type="String">EE S.S. PAYABLE</Data>
</Cell>
- <Cell ss:Index="2">
<Data ss:Type="String">EE S.S. PAYABLE</Data>
</Cell>
- <Cell ss:Index="3">
<Data ss:Type="String">1200</Data>
</Cell>
- <Cell ss:Index="5" ss:StyleID="s22">
<Data ss:Type="Number">1,665.69</Data>
</Cell>
- <Cell ss:Index="6">
<Data ss:Type="Number">0000</Data>
</Cell>
- <Cell ss:Index="7">
<Data ss:Type="Number">000000</Data>
</Cell>
</Row>