This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Re: find the correct rows to apply appropriate templates
- To: xiaocunxu at yahoo dot com
- Subject: [xsl] Re: find the correct rows to apply appropriate templates
- From: Dimitre Novatchev <dnovatchev at yahoo dot com>
- Date: Mon, 4 Jun 2001 21:35:09 -0700 (PDT)
- Cc: xsl-list at lists dot mulberrytech dot com
- Reply-To: xsl-list at lists dot mulberrytech dot com
Hi Xiaocun,
The following stylesheet demonstrates how to find what you call the row number of
the header rows:
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>
<xsl:variable name="firstRowPos" select="1" />
<xsl:variable name="secndRowPos"
select="count(book/sheet/range/row
[cell[1] = '*SupplierOrganizationCode']
/preceding-sibling::row)
+ 1" />
<xsl:variable name="thirdRowPos"
select="count(book/sheet/range/row
[cell[1] = 'EmailAddress']
/preceding-sibling::row)
+ 1" />
<xsl:template match="/">
<xsl:value-of select="concat('secndRowPos: ', $secndRowPos, '
',
'thirdRowPos: ', $thirdRowPos)"/>
</xsl:template>
</xsl:stylesheet>
The result is:
secndRowPos: 5
thirdRowPos: 7
Hope this helped.
Cheers,
Dimitre Novatchev.
P.S. I had to guees and add a book, sheet, and range node containing your sample xml
data.
Xiaocun Xu wrote:
Hi,
I still have a problem trying to convert the generic
XML (generated from spreadsheet, attached at the end
of this message) to the specific XML I needed.
The structure of the generic XML has 4 sections,
each section is consisted of a header row and (1 or
more) detail rows. For each of those sections, I need
to apply a different template.
The problem, how to find the starting and ending row
of each of the sections, and therefore apply the
appropriate templates to those rows?
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list