How do you export a MySQL database content to open up in Excel 2010? The file will download and open up fine in an XP or Vista machine, but in Windows 7, Excel 2010 and earlier says the file is corrupted and advices us to use the Repair tool on the file. Using the Repair tool simply fails silently and the file does not open. Changing the xls extension to csv doesn't open the file in Excel 2010 either. It appears to be a Windows 7 issue, since it displays in Excel in earlier versions of Windows.
Did you have to make any particular updates to your code for display on Windows 7? Is so, what were they?
Does anyone format MySQL data to be downloaded as Excel? I thought it was pretty common. With this format on Win7, it seems that we need to take another look at our code.