Exporting MySQL to Excel 2007 using PHP causes error…?


I am trying to export data from a mysql database to an excel spreadsheet using php. The script works fine in Excel 2003, but in 2007 I get the folowing error:

The file your are trying to open ‘filename.xls’, is in a different format that specified by the file extension. Verify that the file is not corrupted and…

Excel 2007 is extremely picky when it comes to file formats and their actual contents… it’ll even give this error if you use Excel to create an XLS file, and add too many formulas in it… :-/

Try saving the file as a CSV, instead.

i think of what you’re able to do is create an odbc that connects on your excel spreadsheet document so it is taken care of merely like a database. carry out a query on it and shop the end result on your Mysql database

Leave a Comment