[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] problems with position() and following-sibling
My use case:
I have an Excel Sheet in xml format, that is basically build out of 6 columns. Now and then I have a value in column 7, that should be made a footnote in column 2 of the output. Column 1 is to be eliminated in the output (I just use it for grouping). Example Data (6 columns, sometimes 7): <Row> <Cell><Data ss:Type="String">LAS</Data></Cell> <Cell><Data ss:Type="String">Masterreport</Data></Cell> <Cell><Data ss:Type="String">alle 4 Lizenzarten</Data></Cell> <Cell><Data ss:Type="String">Lizenzdruck</Data></Cell> <Cell><Data ss:Type="String">Jasper</Data></Cell> <Cell><Data ss:Type="String">pilot_licence_CH.xml</Data></Cell> <Cell><Data ss:Type="String">Alle Lizenzvorlagen sind in zip-Dateien zusammengefasst.</Data></Cell> </Row> Output should be (5 columns): <row> <entry>Masterreport</entry> <entry>alle 4 Lizenzarten<footnote> <para>Alle Lizenzvorlagen sind in zip-Dateien zusammengefasst.</para> </footnote> </entry> <entry>Lizenzdruck</entry> <entry>Jasper</entry> <entry>pilot_licence_CH.xml</entry> </row> My approach is to use simple template matching for rows and cells: <xsl:template match="Row"> <row> <xsl:apply-templates/> </row> </xsl:template> <xsl:template match="Cell[position() > 1 and position() < 7]"> <entry> <xsl:value-of select="Data"/> <xsl:if test="position()=3 and following-sibling::Cell[7]"> <xsl:message>+++ making footnote +++</xsl:message> <footnote><para><xsl:value-of select="following-sibling::Cell[7]/Data"/></para></footnote> </xsl:if> </entry> </xsl:template>
<xsl:if test="position()=3 and following-sibling::Cell[7]"> I got the impression that position() and following-sibling::e:Cell[x] do not see the "absolute" node positions of the cells in the original tree, but only the filtered set of the match by Cell[position() > 1 and position() < 7], which should result in 5 cells (am I right here?). In consequence, I tried to switch down the node number in the if statement, and with "5" I finally got footnotes (in the first cell) <xsl:if test="following-sibling::e:Cell[5]"> not really knowing why "5" and not "6" (if the position is calculated from the current context node of the first cell?). Any further attempts to refine the statement with position()=2, to move the footnote to the second column, didn't succeed. I have to admit, that my proceeding was "try and error" here (very unsatisfying to me), so can someone please point out, what is going on in my template. Thanks, Georges
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|