HWiNFO 5.22

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).
• GNUMERIC.
• HTML.
• SYLK.
• CSV.

Supported Write File Formats include:

• BIFF 8 (.XLS) Excel 95 and above.
• Office Open XML (.XLSX Excel 2007 and above.
• HTML.
• CSV.
• PDF*.

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.