nested loop

riteshdubey5 · August 29th, 2012, 02:49 AM

Hi,

I wish to get the attribute values as mentioned below:

Input:

<Table xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<Row ss:AutoFitHeight="0" ss:Height="12.5008">
<Cell ss:StyleID="ce1">
<Data ss:Type="String">KEY</Data>
</Cell>
<Cell ss:StyleID="ce1">
<ss:Data xmlns="http://www.w3.org/TR/REC-html40" ss:Type="String">TYPE</ss:Data>

</Cell>
<Cell ss:StyleID="ce1">
<ss:Data xmlns="http://www.w3.org/TR/REC-html40" ss:Type="String">STORAGE</ss:Data>

</Cell>
<Cell ss:StyleID="ce1">
<Data ss:Type="String">DOMAIN</Data>
</Cell>
<Cell ss:StyleID="ce1">
<Data ss:Type="String">DOMAIN2</Data>
</Cell>
<Cell ss:StyleID="ce1">
<Data ss:Type="String">NAME</Data>
</Cell>
<Cell ss:StyleID="ce5">
<Data ss:Type="String">NAME_DE</Data>
</Cell>
<Cell ss:StyleID="ce1">
<Data ss:Type="String">DESCRIPTION</Data>
</Cell>
<Cell ss:StyleID="ce1">
<Data ss:Type="String">DESCRIPTION_DE</Data>
</Cell>
<Cell ss:StyleID="ce1">
<ss:Data xmlns="http://www.w3.org/TR/REC-html40" ss:Type="String">VALUE_TYPE</ss:Data>

</Cell>
<Cell ss:StyleID="ce1">
<ss:Data xmlns="http://www.w3.org/TR/REC-html40" ss:Type="String">ISMULTIVALUE</ss:Data>

</Cell>
<Cell ss:StyleID="ce1">
<ss:Data xmlns="http://www.w3.org/TR/REC-html40" ss:Type="String">ISSEARCHABLE</ss:Data>
<Comment>
<ss:Data xmlns="http://www.w3.org/TR/REC-html40">
<Font html:Face="Arial1">Indicates that this feature should appear in search
dialogs.</Font>
<Font html:Face="Arial1"/>
</ss:Data>
</Comment>
</Cell>
<Cell ss:StyleID="ce1">
<Data ss:Type="String">SORTING</Data>
</Cell>
<Cell ss:StyleID="ce1">
<ss:Data xmlns="http://www.w3.org/TR/REC-html40" ss:Type="String"
>LANGUAGE_TYPE</ss:Data>

</Cell>
<Cell ss:Index="1024"/>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="12.5008">
<Cell ss:StyleID="ce2">
<Data ss:Type="String">guu:werk_id</Data>
</Cell>
<Cell ss:StyleID="ce2">
<Data ss:Type="String">rit:asset-feature</Data>
</Cell>
<Cell ss:StyleID="ce2">
<Data ss:Type="Number">0</Data>
</Cell>
<Cell ss:StyleID="ce2">
<Data ss:Type="String">root.</Data>
</Cell>
<Cell ss:StyleID="ce2">
<Data ss:Type="String">root.</Data>
</Cell>
<Cell ss:StyleID="ce2">
<Data ss:Type="String">Werk-ID</Data>
</Cell>
<Cell ss:StyleID="ce2">
<Data ss:Type="String">Werk-ID</Data>
</Cell>
<Cell ss:Index="1024"/>
</Row>
<Row ss:AutoFitHeight="0" ss:Height="12.5008">
<Cell ss:StyleID="ce2">
<Data ss:Type="String">guu:verlagsbereich</Data>
</Cell>
<Cell ss:StyleID="ce2">
<Data ss:Type="String">rit:asset-feature</Data>
</Cell>
<Cell ss:StyleID="ce2">
<Data ss:Type="Number">0</Data>
</Cell>
<Cell ss:StyleID="ce2">
<Data ss:Type="String">root.</Data>
</Cell>
<Cell ss:StyleID="ce2">
<Data ss:Type="String">root.</Data>
</Cell>
<Cell ss:StyleID="ce2">
<Data ss:Type="String">Verlagsbereich</Data>
</Cell>
<Cell ss:StyleID="ce2">
<Data ss:Type="String">Verlagsbereich</Data>
</Cell>
<Cell ss:Index="1024"/>
</Row>
</Table>

XSLT Code:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0">
<xsl:strip-space elements="*"/>
<xsl:output method="xml" indent="yes"/>
<xsl:template match="Table">

<xsl:for-each select="Row">

<char>
<xsl:for-each select="ancestor::Table/Row[1]/Cell/*:Data">
<xsl:attribute name="{text()}"/>
</xsl:for-each>
</char>
</xsl:for-each>

</xsl:template>

</xsl:stylesheet>

Current Output:

<?xml version="1.0" encoding="UTF-8"?>
<char KEY=""
TYPE=""
STORAGE=""
DOMAIN=""
DOMAIN2=""
NAME=""
NAME_DE=""
DESCRIPTION=""
DESCRIPTION_DE=""
VALUE_TYPE=""
ISMULTIVALUE=""
ISSEARCHABLE=""
SORTING=""
LANGUAGE_TYPE=""/>
<char KEY=""
TYPE=""
STORAGE=""
DOMAIN=""
DOMAIN2=""
NAME=""
NAME_DE=""
DESCRIPTION=""
DESCRIPTION_DE=""
VALUE_TYPE=""
ISMULTIVALUE=""
ISSEARCHABLE=""
SORTING=""
LANGUAGE_TYPE=""/>
<char KEY=""
TYPE=""
STORAGE=""
DOMAIN=""
DOMAIN2=""
NAME=""
NAME_DE=""
DESCRIPTION=""
DESCRIPTION_DE=""
VALUE_TYPE=""
ISMULTIVALUE=""
ISSEARCHABLE=""
SORTING=""
LANGUAGE_TYPE=""/>

Desired Output:

<?xml version="1.0" encoding="UTF-8"?>
<root>
<char KEY="" TYPE="" STORAGE="" DOMAIN="" DOMAIN2="" NAME="" NAME_DE="" DESCRIPTION=""
DESCRIPTION_DE="" VALUE_TYPE="" ISMULTIVALUE="" ISSEARCHABLE="" SORTING=""
LANGUAGE_TYPE=""/>
<char KEY="guu:werk_id" TYPE="rit:asset-feature" STORAGE="0" DOMAIN="root." DOMAIN2="root."
NAME="Werk-ID" NAME_DE="Werk-ID" DESCRIPTION="" DESCRIPTION_DE="" VALUE_TYPE=""
ISMULTIVALUE="" ISSEARCHABLE="" SORTING="" LANGUAGE_TYPE=""/>
<char KEY="guu:verlagsbereich" TYPE="rit:asset-feature" STORAGE="0" DOMAIN="root."
DOMAIN2="root." NAME="Verlagsbereich" NAME_DE="Verlagsbereich" DESCRIPTION=""
DESCRIPTION_DE="" VALUE_TYPE="" ISMULTIVALUE="" ISSEARCHABLE="" SORTING=""
LANGUAGE_TYPE=""/>
</root>

thanks!

mhkay · August 29th, 2012, 03:46 AM

This starts getting difficult once you have empty cells in the spreadsheet, but for the moment it appears to be fully populated, in which case you can do

Code:

<xsl:template match="Table">
  <xsl:variable name="table" select="."/>
  <xsl:for-each select="Row">
    <xsl:variable name="row" select="."/>
            <char>
                <xsl:for-each select="1 to count($table/Row[1]/Cell)">
                    <xsl:variable name="col" select="."/>
                    <xsl:attribute name="$table/Row[1]/Cell[$col]/*:Data"
                                        select=$row/Cell[$col]/*:Data"/>
                </xsl:for-each>
            </char>
   </xsl:for-each>
</xsl:template>