Subject: [xsl] Re: find the correct rows to apply appropriate templates From: Dimitre Novatchev <dnovatchev@xxxxxxxxx> Date: Mon, 4 Jun 2001 21:35:09 -0700 (PDT) |
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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] accessing elements create, Dean Missikowski | Thread | Re: [xsl] Re: find the correct rows, Xiaocun Xu |
[xsl] accessing elements created on, Dean Missikowski | Date | AW: [xsl] variables, Mengel Andre (FV/SLM |
Month |