[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
Nacho Jimenez wrote:
This is OT, but you don't really need XSL for this if you can deal with XML Schema. Excel has a cool ability to take an XML Schema as a 'map'. For example a schema for your spreadsheet would probably look like:
You would import the schema as an XML Map. Then select the cells for a particular element and drop that element on the selection. Then hit Data -> Export and your done.
Re: [xsl] Problem transforming Excel XML Workbook (or how to implement one-more-counter-yet in XSLT)
Subject: Re: [xsl] Problem transforming Excel XML Workbook (or how to implement one-more-counter-yet in XSLT) From: Robert Koberg <rob@xxxxxxxxxx> Date: Wed, 02 Nov 2005 07:13:53 -0500 |
Nacho Jimenez wrote:
Dear all,
I'm stuck like glue trying to get data out of an XML Workbook in Excel, and can't find a solution without recursing to a procedural-style counter.. Let me explain the situation i'm stuck in:
Excel produces an XML file with lots of spurious content, but in the middle of it, i get the following nodes:
This is OT, but you don't really need XSL for this if you can deal with XML Schema. Excel has a cool ability to take an XML Schema as a 'map'. For example a schema for your spreadsheet would probably look like:
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:element name="programas"> <xs:complexType> <xs:sequence> <xs:element name="program" maxOccurs="unbounded"> <xs:complexType> <xs:sequence> <xs:element name="name" type="xs:string" maxOccurs="1"/> <xs:element name="line" type="xs:string" maxOccurs="1"/> <xs:element name="company" type="xs:string" maxOccurs="1"/> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:schema>
You would import the schema as an XML Map. Then select the cells for a particular element and drop that element on the selection. Then hit Data -> Export and your done.
best, -Rob
<snip/>[....] <Row> <Cell><Data ss:Type="String">E-TF-010-16425</Data></Cell> <Cell><Data ss:Type="String">B38379715</Data></Cell> <Cell><Data ss:Type="String">X</Data></Cell> <Cell><Data ss:Type="String">S</Data></Cell> <Cell><Data ss:Type="Number">11144.55</Data></Cell> <Cell ss:Index="16"><Data ss:Type="String">AGP</Data></Cell> <Cell><Data ss:Type="String">Po</Data></Cell> </Row> <Row> <Cell><Data ss:Type="String">E-TF-012-09930</Data></Cell> <Cell><Data ss:Type="String">B38037511</Data></Cell> <Cell><Data ss:Type="String">X</Data></Cell> <Cell><Data ss:Type="String">S</Data></Cell> <Cell ss:StyleID="s45"><Data ss:Type="Number">15734.4</Data></Cell> <Cell><Data ss:Type="String">X</Data></Cell> <Cell ss:Index="16"><Data ss:Type="String">AGP</Data></Cell> <Cell><Data ss:Type="String">Po</Data></Cell> </Row> [...]
<programas> <name>E-TF-012-09930</name> <line>Po</line> <company>AGP</company> </programas>
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Problem transforming Excel XM, Nacho Jimenez | Thread | RE: [xsl] Problem transforming Exce, Michael Kay |
RE: [xsl] Problem transforming Exce, Kaila Kaarle | Date | RE: [xsl] Problem transforming Exce, Michael Kay |
Month |
Keywords