TopXML XSLT library : XML to CSV using XSLT

Home Page

Add/Edit your code items

Search the code library

Browse for the code library

XSLT
XSLT
XSLT Contents
Cross-Browser display of XML/XSL
Cross Reference Lookup in XSLT using XML file as Xref table
Recursion reminds me of Recursion (9 XSLT Recursion examples)
XSLT Sort - output entire xml file with new sort order
Variable Variables
Cross Reference Lookup in XSLT using embedded XML
XTrans 1.0
XML Explorer 2.5
Create an N-Column Table from XML node-set
XSLT Select Option Example
XSLT Date filtering, sorting, comparing, and evaluating
XSLT Template for HTML INPUT Tag
XSLT Template for HTML IMG Tag
XSLT Search and Replace Template
Word wrap and text replace templates for XSLT
nxslt 1.3
Visual XPath
xframe - xsddoc
-xsl-fo-->-pdf--making-an-e-book/documentation.aspx>BIBLE PDF from (xml & xsl)-> xsl-fo -> pdf ; Making an E-book/documentation
Sum(round(.))

<< XQuery .NET and XML >>

By	John Workman
First Posted	05/11/2003
Times viewed	1238

XML to CSV using XSLT

This post contains attachments
v20030511164753.zip

Summary This JScript loads a XML document and XSLT Document. It then transforms the XML document to a CSV file using XSLT.

One thing that the XSLT does is to replace all double quotes with single quotes. The thought behind this is that the csv file will be loaded into another system. The fields are comma delimited, and each value is surrounded by double quotes. If you have double quotes within a value, it will fail upon loading. Here's the JScript:

Additional information
function CreateCSV() { // DECLARE OBJECTS var fso = new ActiveXObject("Scripting.FileSystemObject"); var objDOMDocument = new ActiveXObject("MSXML2.DOMDocument"); var XSLTDoc = new ActiveXObject("MSXML2.DOMDocument"); objDOMDocument.async = false; XSLTDoc.async = false; // LOAD FILES objDOMDocument.load("XML2CSVSource.xml"); XSLTDoc.load("XML2CSVTransform.xsl"); // CREATE OUTPUT FILE var FSObject = fso.CreateTextFile("XML2CSVOutput.csv", true); FSObject.WriteLine(objDOMDocument.transformNode(XSLTDoc)); // CLEAR OBJECTS objDOMDocument = null; XSLTDoc = null; fso = null; } CreateCSV(); ---------------------------------------------------------- Here's the xslt: ---------------------------------------------------------- <xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0' xmlns:msxsl = 'urn:schemas-microsoft-com:xslt'> <xsl:output method='text' omit-xml-declaration='yes' encoding='ASCII'/> <xsl:template match="/"> <xsl:text>"Name","Address","City","State","Zip"</xsl:text> <xsl:value-of select="' '" /> <xsl:for-each select='Doc/Employees/Employee'> <xsl:text>"</xsl:text> <xsl:call-template name='double2single'> <xsl:with-param name='textString'> <xsl:value-of select='@Name'/> </xsl:with-param> </xsl:call-template> <xsl:text>","</xsl:text> <xsl:call-template name='double2single'> <xsl:with-param name='textString'> <xsl:value-of select='@Address'/> </xsl:with-param> </xsl:call-template> <xsl:text>","</xsl:text> <xsl:call-template name='double2single'> <xsl:with-param name='textString'> <xsl:value-of select='@City'/> </xsl:with-param> </xsl:call-template> <xsl:text>","</xsl:text> <xsl:call-template name='double2single'> <xsl:with-param name='textString'> <xsl:value-of select='@State'/> </xsl:with-param> </xsl:call-template> <xsl:value-of select='@Zip'/> <xsl:text>"</xsl:text> <xsl:value-of select="' '"/> </xsl:for-each> </xsl:template> <xsl:variable name='dblQuote'></xsl:variable> <xsl:variable name='sglQuote'>'</xsl:variable> <xsl:template name='double2single' > <xsl:param name='textString' /> <xsl:value-of select="translate($textString,$dblQuote,$sglQuote)"/> </xsl:template> </xsl:stylesheet>

Further additional information
<?xml version='1.0'?> <Doc Version="1.0"> <Employees> <Employee Name="John Workdog Workman" Address="1 Peachtree Street" City="Atlanta" State="GA" Zip="30301" /> <Employee Name="Mark" Address="1 Peachtree Road" City="Atlanta" State="GA" Zip="30302" /> <Employee Name="Mary" Address="1 Peachtree Corners" City="Alpharetta" State="GA" Zip="30303" /> </Employees> </Doc>

Rate this article on a scale of 1 to 10 (1 votes, average 5)

Your vote :

<< XQuery .NET and XML >>


Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown:



	Recent Jobs Software Specialist, Linux - Finland Linux Core Technical Project Manager/ Sc Graphics designer at Tanzania. Experienc Integration Specialist Needed - Work Fro Virtualization Server Infrastructure Arc View all Jobs (Add yours) View all CV (Add yours)



	Partners Dream.In.Code dotNet Slackers dotNet Spider Your HTML Source VisualBuilder.com DevGuru Planet Source Code ZVON.ORG Web Design ASPAlliance XML Pitstop Scripts The Spot 4 SAP Bitshop Web Hosting

Email TopXML