PHPExcel

1.8.0

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.

How useful is this software?

Click on a star to rate it!

Average rating 4.7 / 5. Vote count: 76

No votes so far! Be the first to rate this post.

Version1.8.0
Operating System SupportWindows 8, Windows 2012, Windows 2008, Windows Vista, Windows 7, Windows 2003, Windows XP, Windows 2000, Windows 10, Windows 98
Current LanguageEnglish
Available LanguagesEnglish, French, Polish, Chinese, Italian, German, Japanese, Spanish
LicenseFree
DateTuesday, March 15th 2016
DeveloperMaarten Balliauw
Developer URLhttps://www.blog.maartenballiauw.be

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.

Scroll to Top