Subject: RE: 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/
|