Re: [xsl] Problem transforming Excel XML Workbook (or how to implement one-more-counter-yet in XSLT)

[Robert Koberg <rob@xxxxxxxxxx>]

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>