Subject: RE: [xsl] Converting excel columns/rows to XML using XSL From: "bryan" <bry@xxxxxxxxxx> Date: Fri, 31 Jan 2003 10:42:57 +0100 |
Okay, I haven't tested this but it should be pretty close to what you wanted. === Excel piece: === <Names> <NamedRange ss:Name="name" ss:RefersTo="=Sheet1!R2C1"/> <NamedRange ss:Name="quantity" ss:RefersTo="=Sheet1!R2C4:R10C4"/> <NamedRange ss:Name="yearMonth" ss:RefersTo="=Sheet1!R2C3:R10C3"/> </Names> <Worksheet ss:Name="Sheet1"> <Table ss:ExpandedColumnCount="4" ss:ExpandedRowCount="10" x:FullColumns="1" x:FullRows="1"> <Column ss:AutoFitWidth="0" ss:Width="67.5"/> <Row> <Cell ss:Index="3"><Data ss:Type="String">yearMonth</Data></Cell> <Cell><Data ss:Type="String">quantity</Data></Cell> </Row> <Row> <Cell ss:StyleID="s25"><Data ss:Type="String">Forecast Name</Data><NamedCell ss:Name="name"/></Cell> <Cell ss:Index="3" ss:StyleID="s21"><Data ss:Type="String">2002-01</Data><NamedCell ss:Name="yearMonth"/></Cell> <Cell ss:StyleID="s22"><Data ss:Type="Number">10</Data><NamedCell ss:Name="quantity"/></Cell> </Row> <Row> <Cell ss:Index="3" ss:StyleID="s21"><Data ss:Type="String">2002-02</Data><NamedCell ss:Name="yearMonth"/></Cell> <Cell ss:StyleID="s23"><Data ss:Type="Number">8.29</Data><NamedCell ss:Name="quantity"/></Cell> </Row> <Row> <Cell ss:Index="3" ss:StyleID="s21"><Data ss:Type="String">2002-03</Data><NamedCell ss:Name="yearMonth"/></Cell> <Cell ss:StyleID="s24"><Data ss:Type="Number">3</Data><NamedCell ss:Name="quantity"/></Cell> </Row> <Row> <Cell ss:Index="3" ss:StyleID="s21"><Data ss:Type="String">2002-04</Data><NamedCell ss:Name="yearMonth"/></Cell> <Cell ss:StyleID="s23"><Data ss:Type="Number">4.9</Data><NamedCell ss:Name="quantity"/></Cell> </Row> <Row> <Cell ss:Index="3" ss:StyleID="s21"><Data ss:Type="String">2002-05</Data><NamedCell ss:Name="yearMonth"/></Cell> <Cell ss:StyleID="s24"><Data ss:Type="Number">3</Data><NamedCell ss:Name="quantity"/></Cell> </Row> <Row> <Cell ss:Index="3" ss:StyleID="s21"><NamedCell ss:Name="yearMonth"/></Cell> <Cell ss:StyleID="s23"><NamedCell ss:Name="quantity"/></Cell> </Row> <Row> <Cell ss:Index="3" ss:StyleID="s21"><NamedCell ss:Name="yearMonth"/></Cell> <Cell ss:StyleID="s24"><NamedCell ss:Name="quantity"/></Cell> </Row> <Row> <Cell ss:Index="3" ss:StyleID="s21"><NamedCell ss:Name="yearMonth"/></Cell> <Cell ss:StyleID="s23"><NamedCell ss:Name="quantity"/></Cell> </Row> <Row> <Cell ss:Index="3" ss:StyleID="s21"><NamedCell ss:Name="yearMonth"/></Cell> <Cell ss:StyleID="s24"><NamedCell ss:Name="quantity"/></Cell> </Row> </Table> ===xsl=== <?xml version='1.0'?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"> <xsl:template match="/"> <forecast xmlns="http://www.vivecon.com"> <name> <xsl:apply-templates select="ss:Workbook/ss:Worksheet/ss:Table"/> </name> </forecast> </xsl:template> <xsl:template match="ss:Table"> <xsl:apply-templates select="Row[position() > 1]"/> </xsl:template> <xsl:template match="Row"> <timeQuantity> <xsl:apply-templates/> </timeQuantity> </xsl:template> <xsl:template match="Cell[Data]"> <xsl:variable name="NamedCellValue" select="NamedCell/@ss:Name"/> <xsl:element name="{$NamedCellValue}"><xsl:value-of select="Data"/></xsl:element> </xsl:template> <xsl:template match="*"/> </xsl:stylesheet> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Converting excel columns/rows, Irina Simpson | Thread | Re: [xsl] Converting excel columns/, Irina Simpson |
RE: XSL frustration (was: Re: [xsl], Passin, Tom | Date | Re: XSL frustration (was: Re: [xsl], Tobias Reif |
Month |