[hemant.basvapattan]

hello frds
can someone please help me in creating multiple sheets in excel and populating it with data set. i am able to craete one sheet but while add one more worksheet tag in xls file and run it ,it give me message as corrupted file.




my code

<xsl:stylesheetversion="1.0"

xmlns="urn:schemas-microsoft-comffice:spreadsheet"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

xmlns:msxsl="urn:schemas-microsoft-com:xslt"

xmlns:user="urn:my-scripts"

xmlns="urn:schemas-microsoft-comfficeffice"

xmlns:x="urn:schemas-microsoft-comffice:excel"

xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet" >



<xsl:templatematch="/">

<Workbookxmlns="urn:schemas-microsoft-comffice:spreadsheet"

xmlns="urn:schemas-microsoft-comfficeffice"

xmlns:x="urn:schemas-microsoft-comffice:excel"

xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"



xmlns:html="http://www.w3.org/TR/REC-html40">

<xsl:apply-templates/>

</Workbook>

</xsl:template>



<xsl:templatematch="/*">



<Worksheet>

<xsl:attributename="ss:Name" >

<xsl:value-ofselect="local-name(/*/*)"/>

</xsl:attribute>

<Tablex:FullColumns="1"x:FullRows="1">

<Row>

<xsl:for-eachselect="*[position() = 1]/*">

<Cell><Datass:Type="String">

<xsl:value-ofselect="local-name()"/>

</Data></Cell>

</xsl:for-each>

</Row>

<xsl:apply-templates/>

</Table>

</Worksheet>

</xsl:template>



<xsl:templatematch="/*/*">

<Row>

<xsl:apply-templates/>

</Row>

</xsl:template>



<xsl:templatematch="/*/*/*">

<Cell><Datass:Type="String">

<xsl:value-ofselect="."/>

</Data></Cell>

</xsl:template>



</xsl:stylesheet>