Webmaster Forum / Flash / Data Integration / December 2006

Using Flash 8's XML object and trying to read in XML created in Excel 2003 I
get error -6 back from the XML.status property which means "An XML element was
malformed."

If I export the same data in Excel 2002 it loads corectly. Further
investigation showed that Excel 2002 exports at the begining this

<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"

And Excel 2003 exports an extra line at the begining like this

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"

If I remove the 2nd line the file works! Any ideas why Flash chokes on this
line?

This is an issue as I am building an application for a client who only has
Excel 2003!

Thanks for any input on this.

Kevin