[xsl] Fwd: Parsing Excel - Selecting Ranges

Subject: [xsl] Fwd: Parsing Excel - Selecting Ranges
From: "Luciano Greiner" <luciano.greiner@xxxxxxxxx>
Date: Mon, 20 Oct 2008 22:39:58 -0300
Hello.

I am trying to convert timesheets written in an Excel generated XML.
I got a dificult on selecting ranges of rows representing timesheets.

I can use XSL 2.0.

I need to select Row elements between Rows containing first Cell/Data
child filled with '#' and a clear first Cell/Data.

<Row ...> timesheet start row
<Cell><Data ss:Type="String">#</Data></Cell>
... not needed
</Row>
<Row > #1
<Cell ss:StyleID="s47"><Data ss:Type="Number">1</Data></Cell>
... useful data
</Row>
<Row> #2
<Cell ss:StyleID="s47"><Data ss:Type="Number">2</Data></Cell>
... useful data
</Row>
<Row> timesheet end row
<Cell ss:StyleID="s47"><Data ss:Type="String"></Data></Cell>
... not needed
</Row>

... more timesheets with the same pattern?

Is there any way to inner timesheet rows of timesheets (like #1 and #2)?

Thank you!

--
Luciano Greiner

Current Thread