Subject: Problem while Xpath-ing an excel XML exported file
From: <michella@xxxxxxx>
Date: Thu, 17 Mar 2005 16:41:58 +0100
|
> 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>
|
Cart
