Groups | Blog | Home
all groups > flash data integration > december 2006 >

flash data integration : Flash 8 chokes on XML from Excel 2003


MCR
12/15/2006 12:00:00 AM
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
cinemaguy
12/15/2006 8:40:58 PM
MCR
12/16/2006 12:00:00 AM
AddThis Social Bookmark Button