Welcome to WebmasterWorld Guest from 54.162.255.186

Forum Moderators: open

Message Too Old, No Replies

Excel XML output clean up

     
12:56 pm on Mar 29, 2009 (gmt 0)

New User

5+ Year Member

joined:Mar 29, 2009
posts: 2
votes: 0


Anyone know of any open source or commercial scripts available to convert MS Excel xml output into clean xml code?
8:15 pm on Apr 20, 2009 (gmt 0)

Senior Member from CA 

WebmasterWorld Senior Member httpwebwitch is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Aug 29, 2003
posts:4061
votes: 0


(bump)

Hi Kahodges, welcome to WebmasterWorld!

I presume by the silence that no one has any advice on this topic. Output from MS Office products are notoriously messy... perhaps you can run your XML through an XSLT to select only the nodes you care about, and discard the rest?