Subject: Re: [xsl] Fwd: Parsing Excel - Selecting Ranges From: "Luciano Greiner" <luciano.greiner@xxxxxxxxx> Date: Tue, 21 Oct 2008 19:26:32 -0300 |
Hi Florent. It works, but just when we have only one timesheet. The document may have more timesheets like this: > georgfl@bxl-wrk-090> cat luciano.xml > <sheet> > <Row> > <Cell><Data>#</Data></Cell> > </Row> > <Row> > <Cell><Data>1</Data></Cell> > </Row> > <Row> > <Cell><Data>2</Data></Cell> > </Row> > <Row> > <Cell><Data/></Cell> > </Row> > <Row> > <Cell><Data>#</Data></Cell> > </Row> > <Row> > <Cell><Data>3</Data></Cell> > </Row> > <Row> > <Cell><Data>4</Data></Cell> > </Row> > <Row> > <Cell><Data/></Cell> > </Row> > </sheet> > I need to iterate over two groups (1,2) and (3,4). Do you know how may i do that? Thank you On Tue, Oct 21, 2008 at 9:33 AM, Florent Georges <lists@xxxxxxxxxxxx> wrote: > Luciano Greiner wrote: > > Hi > >> I need to select Row elements between Rows containing first >> Cell/Data child filled with '#' and a clear first Cell/Data. > > You can use the << and >> operators: > > georgfl@bxl-wrk-090> cat luciano.xsl > <xsl:stylesheet > xmlns:xsl="http://www.w3.org/1999/XSL/Transform" > version="2.0"> > > <xsl:output indent="yes"/> > > <xsl:template match="/sheet"> > <xsl:variable name="first" as="element(Row)" select=" > Row[Cell/Data eq '#']"/> > <xsl:variable name="last" as="element(Row)" select=" > Row[Cell/Data eq '']"/> > <xsl:sequence select=" > Row[. >> $first][. << $last]/Cell/Data"/> > </xsl:template> > > </xsl:stylesheet> > > georgfl@bxl-wrk-090> cat luciano.xml > <sheet> > <Row> > <Cell><Data>#</Data></Cell> > </Row> > <Row> > <Cell><Data>1</Data></Cell> > </Row> > <Row> > <Cell><Data>2</Data></Cell> > </Row> > <Row> > <Cell><Data/></Cell> > </Row> > </sheet> > > georgfl@bxl-wrk-090> saxon -s:luciano.xml -xsl:luciano.xml > <?xml version="1.0" encoding="UTF-8"?> > <Data>1</Data> > <Data>2</Data> > > Regards, > > -- > Florent Georges > http://www.fgeorges.org/ > > -- Luciano Greiner
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Fwd: Parsing Excel - Sele, Florent Georges | Thread | RE: [xsl] Fwd: Parsing Excel - Sele, Michael Kay |
Re: [xsl] FO: gap between cells in , Florent Georges | Date | RE: [xsl] Fwd: Parsing Excel - Sele, Michael Kay |
Month |