[xsl] Problem while Xpath-ing an excel XML exported file

[<michella@xxxxxxx>]

> Hi all,
>
> I'm really in trouble getting my xsl-t working properly. Here is the
> following (very trivial) xsl code :
>
> <xsl:stylesheet version="1.1"
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
> 	<xsl:output method="xml" version="1.0" encoding="UTF-16"
> indent="yes"/>
> 	<xsl:template match="/">
> 		<xsl:for-each select="Workbook/Worksheet/Table/Row">
> 			<xsl:text>testestestestsetsetestse</xsl:text>
> 		</xsl:for-each>
> 	</xsl:template>
> </xsl:stylesheet>
>
> And here the XML Source (part of it). It is an XML export of an excel
> file (containing only a table with data in it). Here only one row has
> been copied, as to avoid loosing too much space in here. I'm Unable to
> XPATH Workbook/Worksheet/Table/Row (as showed in xsl code). I
> really... really don't understand what's happening. The XML code
> structure seems ok! Any help would be greatful!
>
> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
> xmlns:o="urn:schemas-microsoft-com:office:office"
> xmlns:x="urn:schemas-microsoft-com:office:excel"
> xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
> xmlns:html="http://www.w3.org/TR/REC-html40";>
> 	<DocumentProperties
> xmlns="urn:schemas-microsoft-com:office:office">
> 		<LastAuthor>michella</LastAuthor>
> 		<Created>2005-03-17T10:43:20Z</Created>
> 		<Version>10.6714</Version>
> 	</DocumentProperties>
> 	<OfficeDocumentSettings
> xmlns="urn:schemas-microsoft-com:office:office">
> 		<AllowPNG/>
> 		<PixelsPerInch>72</PixelsPerInch>
> 	</OfficeDocumentSettings>
> 	<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
> 		<WindowHeight>7005</WindowHeight>
> 		<WindowWidth>10005</WindowWidth>
> 		<WindowTopX>105</WindowTopX>
> 		<WindowTopY>105</WindowTopY>
> 		<ProtectStructure>False</ProtectStructure>
> 		<ProtectWindows>False</ProtectWindows>
> 	</ExcelWorkbook>
> 	<Styles>
> 		<Style ss:ID="Default" ss:Name="Normal">
> 			<Alignment ss:Vertical="Bottom"/>
> 			<Borders/>
> 			<Font ss:Color="#000000"/>
> 			<Interior/>
> 			<NumberFormat/>
> 			<Protection/>
> 		</Style>
> 		<Style ss:ID="s25">
> 			<Interior ss:Color="#C0C0C0"
> ss:Pattern="Solid"/>
> 		</Style>
> 	</Styles>
> 	<Worksheet ss:Name="Sheet 1">
> 		<Table ss:ExpandedColumnCount="256"
> ss:ExpandedRowCount="127" x:FullColumns="1" x:FullRows="1"
> ss:DefaultColumnWidth="60">
> 			<Column ss:AutoFitWidth="0" ss:Width="64.5"/>
> 			<Column ss:AutoFitWidth="0" ss:Width="81.75"/>
> 			<Column ss:AutoFitWidth="0" ss:Width="104.25"/>
> 			<Column ss:AutoFitWidth="0" ss:Width="97.5"/>
> 			<Column ss:AutoFitWidth="0" ss:Width="48"/>
> 			<Column ss:AutoFitWidth="0" ss:Width="63"/>
> 			<Column ss:AutoFitWidth="0" ss:Width="48"/>
> 			<Column ss:AutoFitWidth="0" ss:Width="63"/>
> 			<Column ss:AutoFitWidth="0" ss:Width="48"
> ss:Span="247"/>
> 			<Row>
> 				<Cell ss:StyleID="s25">
> 					<Data
> ss:Type="String">DATUM_ZEIT</Data>
> 				</Cell>
> 				<Cell ss:StyleID="s25">
> 					<Data
> ss:Type="String">GEOGRAPHISCH</Data>
> 				</Cell>
> 				<Cell ss:StyleID="s25">
> 					<Data
> ss:Type="String">LEISTUNGSANGEBOT</Data>
> 				</Cell>
> 				<Cell ss:StyleID="s25">
> 					<Data
> ss:Type="String">VERABEITUNGSART</Data>
> 				</Cell>
> 				<Cell ss:StyleID="s25">
> 					<Data
> ss:Type="String">FORMAT</Data>
> 				</Cell>
> 				<Cell ss:StyleID="s25">
> 					<Data
> ss:Type="String">ZUSTELLART</Data>
> 				</Cell>
> 				<Cell ss:StyleID="s25">
> 					<Data
> ss:Type="String">MENGE</Data>
> 				</Cell>
> 				<Cell ss:StyleID="s25">
> 					<Data
> ss:Type="String">KORREKTUR</Data>
> 				</Cell>
> 			</Row>
> 		</Table>
> 		<WorksheetOptions
> xmlns="urn:schemas-microsoft-com:office:excel">
> 			<PageSetup>
> 				<Header x:Margin="0"/>
> 				<Footer x:Margin="0"/>
> 				<PageMargins x:Bottom="0.984251969"
> x:Left="0.78740157499999996" x:Right="0.78740157499999996"
> x:Top="0.984251969"/>
> 			</PageSetup>
> 			<NoSummaryColumnsRightDetail/>
> 			<Print>
> 				<ValidPrinterInfo/>
>
> <HorizontalResolution>600</HorizontalResolution>
>
> <VerticalResolution>600</VerticalResolution>
> 			</Print>
> 			<PageBreakZoom>100</PageBreakZoom>
> 			<Selected/>
> 			<ProtectObjects>False</ProtectObjects>
> 			<ProtectScenarios>False</ProtectScenarios>
> 		</WorksheetOptions>
> 	</Worksheet>
> </Workbook>