This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Converting an xml file into an excel file using XSLT
- To: xsl-list at mulberrytech dot com
- Subject: Converting an xml file into an excel file using XSLT
- From: prasadm at crt dot com
- Date: Thu, 20 Apr 2000 14:17:07 -0500
- Reply-To: xsl-list at mulberrytech 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