Converting an xml file into an excel file using XSLT

[prasadm at crt dot com]

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@crt.com <mailto:prasadm@crt.com> 



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list