I have created this stylesheet for XML source. But when i open the excel sheet it displays the rows as colummns. what am i doing wrong. please help.

<?xml version="1.0" ?>
<ROWSET>
    <ROW>
                <EMAIL_ADDRESS>[email protected]</EMAIL_ADDRESS>
                <FULL_NAME>Brookes, Allan</FULL_NAME>
                <AMOUNT_LIMIT>200000</AMOUNT_LIMIT>
    </ROW>
    <ROW>
     <EMAIL_ADDRESS>[email protected]</EMAIL_ADDRESS>
     <FULL_NAME>Brookes, Allan</FULL_NAME>
     <AMOUNT_LIMIT>50000</AMOUNT_LIMIT>
    </ROW>
    <ROW>
         <EMAIL_ADDRESS>[email protected]</EMAIL_ADDRESS>
     <FULL_NAME>Born, Martha</FULL_NAME>
     <AMOUNT_LIMIT>25000</AMOUNT_LIMIT>
    </ROW>
</ROWSET>

in the excel sheet it displays like this

ns1:Name Data ns1:Type
HR_Hierarchy_feed_to_CT_ [email protected] String
Hierarchy_feed_to_CT_ Brookes, Allan String
HR_Hierarchy_feed_to_CT_ 200000 Number
HR_Hierarchy_feed_to_CT_ [email protected] String
HR_Hierarchy_feed_to_CT_ Brookes, Allan String
HR_Hierarchy_feed_to_CT_ 50000 Number
HR_Hierarchy_feed_to_CT_ [email protected] String
HR_Hierarchy_feed_to_CT_ Born, Martha String
HR_Hierarchy_feed_to_CT_ 25000 Number

I want it like this
[email protected] Brookes, Allan 200000
[email protected] Brookes, Allan 50000
[email protected] Born, Martha 25000


XSL Stylesheet

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel">
<xsl:template match="/">
<Workbook>
<Worksheet ss:Name="HR_Hierarchy_feed_to_CT_">
  <Table>
<xsl:for-each select="ROWSET/ROW">
<ROW>

  <Cell>
            <Data ss:Type="String">
<xsl:value-of select="EMAIL_ADDRESS"/>
</Data>
        </Cell>

 <Cell>
            <Data ss:Type="String">
<xsl:value-of select="FULL_NAME"/>
</Data>
        </Cell>

<Cell>
            <Data ss:Type="Number">
<xsl:value-of select="AMOUNT_LIMIT"/>
</Data>
 </Cell>

</ROW>
</xsl:for-each>
</Table>
</Worksheet>
</Workbook>
</xsl:template>
</xsl:stylesheet>

I am not particular familiar with the Excel XML format but an example I have here has most elements in the namespace urn:schemas-microsoft-com:office:spreadsheet so you need e.g.
and then with XML tag names are case-sensitive so use
for the Excel Row elements.


--
  Martin Honnen
  Microsoft MVP - XML

I changed the <ROW> tags to <Row> but i got the same output.

Did you change the namespace as well?

--
  Martin Honnen
  Microsoft MVP - XML

I changed the namespace then it worked. Thanks very much.
what is the difference in my namespace and the one you have given?

Their is no difference in the namespace itself, rather where it is applied to.
With xmlns="urn:schemas-microsoft-com:office:spreadsheet" it is the default namespace to be applied to all elements that don't have a prefix in their name.
With xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" it only applies to attributes and elements having the prefix 'ss' in their name.
So to make sure the Workbook, Worksheet and other elements are in the Excel namespace urn:schemas-microsoft-com:office:spreadsheet you need a default namespace declaration. Or you would need to qualify all elements with the prefix 'ss' e.g. ss:Workbook.

--
  Martin Honnen
  Microsoft MVP - XML