Wrox Programmer Forums
Go Back   Wrox Programmer Forums > XML > XSLT
XSLT General questions and answers about XSLT. For issues strictly specific to the book XSLT 1.1 Programmers Reference, please post to that forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the XSLT section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old December 8th, 2003, 02:05 AM
Registered User
Join Date: Dec 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default convert xml to csv


I'm getting xml back with CSV data but when it loads into excel it fails and returns an empty worksheet. How do i fix this? This is the XML i am receiving.How do i set it up so that it loads directly into excel.

<Response><ResponseWrapper><CSV>CustomerPartyID,La st/Business Name,First Name,Middle Name,Birth Date,ABN,Product Code,Product Name,Contract Number,Employer Number,Employer Name,Relationship to Contract,Contract Status,Address Line 1,Address Line 2,Address Line 3,Address Line 4,PostCode,Suburb,State,Personal Email Address,Business Email Address,Home Phone Number,Business Phone Number,Mobile Phone Number,
1,Block,T,M,01/08/199,,P,Guaranteed ,N33Z,,Ann,Active,49 WAV ,HORSH NSW,,,0900,HORSH,NSW,,,,,,

Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert 1 big XML to multiple smaller XML victorcorey XSLT 1 March 20th, 2008 05:59 AM
.csv to xml conversion balakrishna XML 0 March 5th, 2007 01:07 PM
XML conversion to CSV - Problem with value ccurtiss1977 XSLT 1 December 22nd, 2006 10:40 AM
CSV and XML with PHP NEO1976 PHP How-To 1 July 17th, 2006 02:33 AM
XML to CSV reloader2 XML 2 September 7th, 2005 08:51 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.