mfowler1

Hi, 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