I'm having a few problems with the XSLT below. I am tring to associate the <Style> tag to <Cell> and thus apply the associated formatting info to the resultant <Entry>. This is for a CALS translation. I can't seem to get any more info from the source file once I implement this. In addition to which I am having to do all this after converting the source tags to upper case. Can anyone help?

############################

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

    <xsl:template match="/">
        <xsl:apply-templates/>
    </xsl:template>
    <xsl:template name="entry-format" match="WORKBOOK">
        <ROOT>
            <xsl:for-each select="/WORKBOOK/WORKSHEET/TABLE/ROW/CELL">
                            <xsl:variable name="span" select="@MERGEACROSS"/>


                <xsl:variable name="c" select="@STYLEID"/>

                <xsl:value-of select="CELL"/>
                <xsl:variable name="cell" select="."/>
                <!--CC>
                    <xsl:value-of select="$cell"/>
                    </CC!-->

                <xsl:for-each select="/WORKBOOK/STYLES/STYLE[@ID=$c]">
                <xsl:variable name="align" select="ALIGNMENT/@HORIZONTAL"/>

                    <xsl:variable name="v" select="@ID"/>

                    <ENTRY ALIGN="{$align}" SPAN="{$span}">
                        <xsl:value-of select="$cell"/>
                        <xsl:value-of select="."/>
                    </ENTRY>
                </xsl:for-each>
            </xsl:for-each>
        </ROOT>
    </xsl:template>
</xsl:stylesheet>

#####################################

Thanks

D.R

Without the source xml it's hard to say what's wrong but two points. Firstly why do you need to convert to uppercase, just change your paths to use lowercase?
Secondly your stylesheet does not have any of the namespace mappings that Excel normally has, these need to be included, usually in the xsl:stylesheet element.
If it's difficult to show the relevant portion of source xml and you're still having difficulties email a simple version as is possible to me off-list.

--

Joe