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>
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--