[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

RE: [xsl] Fwd: Parsing Excel - Selecting Ranges


Subject: RE: [xsl] Fwd: Parsing Excel - Selecting Ranges
From: "Michael Kay" <mike@xxxxxxxxxxxx>
Date: Wed, 22 Oct 2008 00:11:06 +0100

>  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?

<xsl:for-each-group select="Row" group-starting-with="Row[Cell/Data='#']">

Then select within current-group() for the rows you actually want.

Michael Kay
http://www.saxonica.com/


Current Thread