If you need to use PHP to create and interact with Microsoft's Excel spreadsheet app, then using PHPExcel is a good way to go.
PHPExcel is a library that has been written in PHP and has a complete set of classes, which will allow you to write to and read from different spreadsheet file formats, such as Excel (BIFF) .XLS, Excel 2007 (OFFICEOPENXML) .XLSX, CSV, LIBRE/OPENOFFICECALC .ODS, GNUMERIC, PDF, and HTML. Because PHPExcel interacts not only with MS Excel but also with other formats, it can be a little hard to get started.
Supported Read File Formats include:
- BIFF 5-8 (.XLS) Excel 95 and above.
- Office Open XML (.XLSX) Excel 2007 and above.
- SpreadsheetML (.XML) Excel 2003.
- Open Document Format/OASIS (.ODS).
Supported Write File Formats include:
- BIFF 8 (.XLS) Excel 95 and above.
- Office Open XML (.XLSX Excel 2007 and above.
Overall, PHPExcel allows you to read, write and create Excel documents in PHP. The only downside is the learning curve; it can be a tad tricky to use, especially for novices.
*By utilising tcPDF, DomPDF or mPDF libraries, which need to be installed separately.
We don't have any change log information yet for version 1.8.0 of PHPExcel. Sometimes publishers take a little while to make this information available, so please check back in a few days to see if it has been updated.
Can you help?
If you have any change log info you can share with us, we'd love to hear from you! Head over to our Contact page and let us know.