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 |
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:
<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>
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 |