RE: Fwd: Parsing Excel - Selecting Ranges

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