[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
[xsl] Problem while Xpath-ing an excel XML exported file
Subject: [xsl] 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>
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] question about filling of, David Carlisle | Thread | Re: [xsl] Problem while Xpath-ing a, David Carlisle |
RE: [xsl] question about filling of, Armand Datema | Date | Re: [xsl] question about filling of, David Carlisle |
Month |