|
| | | Altova Mailing List Archives>Archive Index >microsoft.public.xml Archive Home >Recent entries >Thread Prev - Re: Convert XML to Excel using XSL >Thread Next - Re: Convert XML to Excel using XSL Re: Convert XML to Excel using XSLTo: NULL Date: 7/2/2004 7:26:00 AM My data.xml file <?xml version="1.0"?> <?xml-stylesheet type="text/xsl" href="TestData.xslt"?> <dealsetup> <dealnbr>1</dealnbr> <name>USING FOR DEAL COPY</name> </dealsetup> And my TestData.xslt file.... <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns="http://www.w3.org/TR/REC-html40"> <xsl:output method="html" omit-xml-declaration="yes" /> <xsl:template match="/"> <HTML> <HEAD> <xsl:text disable-output-escaping="yes"><</xsl:text>meta name="ProgId content=Excel.Sheet" /<xsl:text disable-output-escaping="yes">></xsl:text> <xsl:text disable-output-escaping="yes"><</xsl:text>meta name="Generator" content="Microsoft Excel 10" /<xsl:text disable-output-escaping="yes">></xsl:text> <xsl:text disable-output-escaping="yes"><</xsl:text>link rel=File-List href="out_files/filelist.xml"<xsl:text disable-output-escaping="yes">></xsl:text> <xsl:text disable-output-escaping="yes"><</xsl:text><![CDATA[!--[if gte mso 9]]]><xsl:text disable-output-escaping="yes">></xsl:text> <xml> <x:ExcelWorkbook> <x:ExcelWorksheets> <xsl:call-template name="CreateWorkSheet"> <xsl:with-param name="WorkSheetName">First Sheet</xsl:with-param> </xsl:call-template> <xsl:call-template name="CreateWorkSheet"> <xsl:with-param name="WorkSheetName">Second Sheet</xsl:with-param> </xsl:call-template> <xsl:call-template name="CreateWorkSheet"> <xsl:with-param name="WorkSheetName">Third Sheet</xsl:with-param> </xsl:call-template> </x:ExcelWorksheets> <x:ActiveSheet>0</x:ActiveSheet> </x:ExcelWorkbook> </xml> <xsl:text disable-output-escaping="yes"><</xsl:text><![CDATA[![endif]--]]><xsl: text disable-output-escaping="yes">></xsl:text> </HEAD> <BODY> <H2>Summary</H2> <xsl:for-each select="dealsetup"> <BR>DealNbr: <xsl:value-of select="dealnbr"/></BR> <BR>Name: <xsl:value-of select="name"/></BR> </xsl:for-each> </BODY> </HTML> </xsl:template> <xsl:template name="CreateWorkSheet"> <xsl:param name="WorkSheetName"/> <x:ExcelWorksheet> <x:Name><xsl:value-of select="$WorkSheetName"/></x:Name> <x:WorksheetOptions> <x:Selected/> <x:ProtectContents>False</x:ProtectContents> <x:ProtectObjects>False</x:ProtectObjects> <x:ProtectScenarios>False</x:ProtectScenarios> </x:WorksheetOptions> </x:ExcelWorksheet> </xsl:template> </xsl:stylesheet> Try opening data.xml file in excel. This creates multiple work sheets. Rani *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! | |
| | ||||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
