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
[....]
<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>
[...]
<snip/>
<programas>
<name>E-TF-012-09930</name>
<line>Po</line>
<company>AGP</company>
</programas>
--~------------------------------------------------------------------
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>
--~--