I want to use stock price information from Yahoo Finance which is delivered in xls format. I am having problems converting the spreadsheet data (symbol, date, open, high, low, close, volume) into a FusionCharts compatible xml format.

The xml I generate looks similar to this:

<root>
  <row>
     <Symbol>XYZ</Symbol>
     <Date>2002-01-01T00:00:00</Date>
     <Open>176</Open>
     <High>176</High>
     <Low>176</Low>
     <Close>176</Close>
     <Volume>0</Volume>
   </row>

etc

Fusion charts uses a single line with multiple attributes:

<data>
 <set open='24.6' high='25.24' low='24.58' close='25.19' />

Can anyone recommend an XML tool to convert XLS to XML in the correct format?

Many thanks,

Michael