how to get value in xml attribute through xslt to variable

Question

XML:

<sheet>
    <row num="4">
        <cell num="1">Customer CODE</cell>
        <cell num="2">2213213</cell>
    </row>
    <row num="5">
        <cell num="1">header</cell>
        <cell num="4">12312</cell>
    </row>
</sheet>

I want to set to variable value 5. Because in 5th row there is cell[@num='1'] which equals to header.

This is just returns true

<xsl:variable name="header_pos" select="//row/cell[@num='1']='header'"/>

But I don't know how to get row num value for that cell.. Could you please help

Tim C · Accepted Answer · 2013-06-26 12:47:31Z

4

This is the expression you are looking for:

<xsl:variable name="header_pos" select="//row[cell[@num='1']='header']/@num"/>

i.e Get the row when the cell, with attribute num = '1', has a value of 'header'

answered Jun 26, 2013 at 12:47

Tim C

70.7k14 gold badges77 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

vendettamit · Accepted Answer · 2013-06-26 13:02:11Z

2

Try this:

<table xsl:version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:variable name="header_pos" select="sheet/row/cell/@num" />
<xsl:value-of select="$header_pos" separator=", "/>
</table>

answered Jun 26, 2013 at 13:02

vendettamit

14.7k2 gold badges36 silver badges56 bronze badges

Collectives™ on Stack Overflow

how to get value in xml attribute through xslt to variable

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related