You may THINK you will never need this tip, but you will, oh yes indeed. One day, someone is going to hand you an Excel spreadsheet and say "hey, make this look cool". And then you will spend hours and hours doing Google searches on variations of the keywords "Excel", "export", "XML", "Holy Grail", etc.
The easiest way I've found to export "Flash Developer-Friendly" (tm) XML from an Excel spreadsheet is to import the spreadsheet into Access, and then export the table or query from Access into XML. This is assuming that the first row in your Excel spreadsheet contains column headers.
-Sam
Posted by samuel at February 11, 2004 03:38 AM