Subject: Converting an xml file into an excel file using XSLT From: prasadm@xxxxxxx Date: Thu, 20 Apr 2000 14:17:07 -0500 |
I am trying to convert an xml file into an excel file using XSLT. Attached below is a sample code snippet from both the xml and xsl file I am using jclarks XT to do the transformation. The error returned by the parser is not helpful. Also, I am sure that the tab(\t) and \0 used are incorrect. I don't know their character values(entity). Is this the right way to convert xml file to excel file or am I doing wrong? Any help in this regard is really appreciated. xml file :- <?xml version="1.0"?> <ROWSET> <ROW num="1"> <WF_AUDIT_CDATE><![CDATA[01-Oct-1999 09:17:13 AM]]></WF_AUDIT_CDATE> <DOC_ID><![CDATA[10000311]]></DOC_ID> <DOC_TYPE_DSCR><![CDATA[Confirm(Initial)-In]]></DOC_TYPE_DSCR> <QUEUE_DSCR><![CDATA[BackOffice-Check]]></QUEUE_DSCR> <ACTION_DSCR><![CDATA[Add WP to current user's inbox]]></ACTION_DSCR> <USER_NAME><![CDATA[Hammond, Jane]]></USER_NAME> </ROW> <ROW num="2"> <WF_AUDIT_CDATE><![CDATA[01-Oct-1999 09:22:31 AM]]></WF_AUDIT_CDATE> <DOC_ID><![CDATA[10000311]]></DOC_ID> <DOC_TYPE_DSCR><![CDATA[Confirm(Initial)-In]]></DOC_TYPE_DSCR> <QUEUE_DSCR><![CDATA[BackOffice-Check]]></QUEUE_DSCR> <ACTION_DSCR><![CDATA[Move WP to another queue]]></ACTION_DSCR> <USER_NAME><![CDATA[Hammond, Jane]]></USER_NAME> </ROW> </ROWSET> xsl file :- <?xml version="1.0"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <xsl:apply-templates/> </xsl:template> <xsl:template match="ROWSET"> WF_AUDIT_CDATE \t DOC_ID \t DOC_TYPE_DSCR \t QUEUE_DSCR \t ACTION_DSCR \t USER_NAME \0 <xsl:apply-templates/> </xsl:template> <xsl:template match="ROW"> <xsl:apply-templates/> \0 </xsl:template> <xsl:template match="ROW/*"> <xsl:apply-templates/> </xsl:template> </xsl:stylesheet> Prasad M Home:- 630-595-0642 Work:- 312-974-6543 prasadm@xxxxxxx <mailto:prasadm@xxxxxxx> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: Newbie question, DuCharme, Robert | Thread | Re: Converting an xml file into an , Mike Brown |
Newbie question, yue . m . ma | Date | Re: XML/XSL..., Jagadha Sivan |
Month |