Sunday, October 19, 2014

PHPExcel (File format or extension not valid)

Hello Fellows,
I'm using PhpExcel (by Segy -> https://github.com/segy/PhpExcel ) for export my query in excel file; however after I created file(which is xslx format), I can not open my file in excel. It gives "the file format or extension is not valid. 
I've tried to reduce the problem by only:
    creating the WorkSheet: $this->PhpExcel->createWorksheet();,
    adding a Table Header: $this->PhpExcel->addTableHeader($table, array('name' => 'Cambria', 'bold' => true));,
    adding a TableRow $this->PhpExcel->addTableRow(..)
    and calling $this->PhpExcel->output(); to generate the file

and the problem it's still there.

Any suggestions about how I can fix it?

Thanks for reading.


--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

No comments: