XSL : How to get particular node value of a table

prao2005

My XML Code

Expand|Select|Wrap|Line Numbers

 
 <DBE:Attribute name="Test1" type="Table">

      <DBE:Table>

         <DBE:TableHeader>

            <DBE:TableColumn>t1</DBE:TableColumn>

            <DBE:TableColumn>t2</DBE:TableColumn>

            <DBE:TableColumn>t3</DBE:TableColumn>

            <DBE:TableColumn>t4</DBE:TableColumn>

            <DBE:TableColumn>t5</DBE:TableColumn>

            <DBE:TableColumn>t6</DBE:TableColumn>

            <DBE:TableColumn>t7</DBE:TableColumn>

            <DBE:TableColumn>t8</DBE:TableColumn>

            <DBE:TableColumn>t9</DBE:TableColumn>

            <DBE:TableColumn>t10</DBE:TableColumn>

            <DBE:TableColumn>t11</DBE:TableColumn>

            <DBE:TableColumn>t12</DBE:TableColumn>

            <DBE:TableColumn>t13</DBE:TableColumn>

         </DBE:TableHeader>

         <DBE:TableRow>

            <DBE:TableData>0300 </DBE:TableData>

            <DBE:TableData/>

            <DBE:TableData>25</DBE:TableData>

            <DBE:TableData>25</DBE:TableData>

            <DBE:TableData>2009/09/03</DBE:TableData>

            <DBE:TableData/>

            <DBE:TableData>BAG</DBE:TableData>

            <DBE:TableData>rrr</DBE:TableData>

            <DBE:TableData>Yes</DBE:TableData>

            <DBE:TableData>12</DBE:TableData>

            <DBE:TableData>2009/03/09</DBE:TableData>

            <DBE:TableData>GO</DBE:TableData>

            <DBE:TableData/>

         </DBE:TableRow>

      </DBE:Table>

   </DBE:Attribute>

I would like my output to be ->
t7 t5 t1 t13 --> Header
---------------------------------------------------------------
BAG 2009/09/03 0300 GO --> ROW1
.................................................. ............ --> ROW2

and so on

My XSL code --> (for only selected values to be displayed)

Expand|Select|Wrap|Line Numbers

 
               <xsl:for-each select="DBE:Attribute[@name='Test1']/DBE:Table/DBE:TableRow">

              <tr bgcolor="white">

                      <xsl:for-each select="DBE:TableData">

                 <td>

        <xsl:value-of select="node()|*">
 
                </xsl:value-of> 

             </td>

              </xsl:for-each>

              </tr>

           </xsl:for-each>

samueln12

Sample for your reference:

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<xsl:stylesheet  version="2.0"

    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

    xmlns:DBE="http://schemas.microsoft.com/office/word/2003/wordml">

    <xsl:template match="*">

        <xsl:copy>

            <xsl:copy-of select="@*"/>

            <xsl:apply-templates/>

        </xsl:copy>

    </xsl:template>

    <xsl:template match="DBE:TableRow">

        <tr>

            <xsl:for-each select="child::DBE:TableData[count(preceding-sibling::DBE:TableData)+1=7]">

                <td>

                    <xsl:apply-templates/>

                </td>

            </xsl:for-each>

            <xsl:for-each select="child::DBE:TableData[count(preceding-sibling::DBE:TableData)+1=5]">

                <td>

                    <xsl:apply-templates/>

                </td>

            </xsl:for-each>

            <xsl:for-each select="child::DBE:TableData[count(preceding-sibling::DBE:TableData)+1=1]">

                <td>

                    <xsl:apply-templates/>

                </td>

            </xsl:for-each>

            <xsl:for-each select="child::DBE:TableData[count(preceding-sibling::DBE:TableData)+1=12]">

                <td>

                    <xsl:apply-templates/>

                </td>

            </xsl:for-each>

        </tr>

    </xsl:template>

</xsl:stylesheet>

prao2005

I applied the logic shared by you...and got the expected values.

Thanks a lot.!!!
It worked....................

XSL : How to get particular node value of a table

re: XSL : How to get particular node value of a table

re: XSL : How to get particular node value of a table

Similar XML bytes

/bytes/development

/bytes/it

/bytes/about