-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Pithvi
Message 2 in Discussion
Hi Vikash, You can convert XML data to Ms-Excel using XSL. I
have done that long back. Here is a sample XSL. I am not sure whether this will give
you a proper result. You can use this as a start-up. Apply this xsl to your xml file.
<xsl:template match="result">
<xsl:for-each select="column">
<gmr:Cell Row="0" ValueType="60">
<xsl:variable name="colnumber"><xsl:number level="single"
from="column" count="column"/></xsl:variable>
<xsl:attribute name="Col">
<xsl:value-of select="$colnumber"/>
</xsl:attribute>
<gmr:Content>
<xsl:apply-templates select="." mode="value"/>
</gmr:Content>
</gmr:Cell>
</xsl:for-each>
<xsl:for-each select="row">
<xsl:apply-templates select=".">
<xsl:with-param name="rownumber" select="position()"/>
</xsl:apply-templates>
</xsl:for-each>
</xsl:template>
<xsl:template match="row">
<xsl:param name="rownumber" select="1"/>
<xsl:for-each select="*">
<xsl:apply-templates select=".">
<xsl:with-param name="rownumber" select="$rownumber"/>
<xsl:with-param name="colnumber" select="position()"/>
</xsl:apply-templates>
</xsl:for-each>
</xsl:template>
<xsl:template match="*">
<!-- avoids Result Tree Fragments -->
<xsl:param name="rownumber" select="0"/>
<xsl:param name="colnumber" select="0"/>
<gmr:Cell ValueType="60" Col="{$colnumber}" Row="{$rownumber}">
<xsl:value-of select="."/>
</gmr:Cell>
</xsl:template>
-cheers- Prithvi
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
