xsl-list
[Top] [All Lists]

need help extracting data from xml with xmlss format

2004-05-17 19:18:58
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>




<Prev in Thread] Current Thread [Next in Thread>