Export to excel in php
Posted: Thu Jul 02, 2009 6:13 am
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 is from a trusted srouce before opening the file. Do you want to open the file now?
You can still click "yes" and open the file. Anyone know a way to solve this annoyance?
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 is from a trusted srouce before opening the file. Do you want to open the file now?
You can still click "yes" and open the file. Anyone know a way to solve this annoyance?