Search code examples
phpphpexcelxls

PHPExcel file not in the proper Microsoft Excel 2003 XLS format

I'm generating a Excell 2003 using PHPExcel 1.8 with this code:

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('toUploadFtp.xls');

The file seems ok, and I can read it using MS Office and LibreOffice.

But I have to upload the file to a system that says the format has to be Excell 2003, and he prompts next error:

Oops! Your file is not in the proper Microsoft Excel 2003 XLS format.

If I open the file with LibreOffice and save it again, then I can upload the file correctly to the system.

Any idea?

Thanks,

Solution

  • Finally I couldn't find a solution. It has to be some kind of bug in the XLS 2003 format.

    But I generated a XLSX with $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); and the system recognizes it correctly.