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