PHPOffice/PHPExcel

9 years ago
admin
2 minutes

PHPExcel is a library written in pure PHP and providing a set of classes that allow you to write to and read from different spreadsheet file formats, like Excel (BIFF) .xls, Excel 2007 (OfficeOpenXML) .xlsx, CSV, Libre/OpenOffice Calc .ods, Gnumeric, PDF, HTML, … This project is built around Microsoft’s OpenXML standard and PHP.

**WARNING: **This branch breaks backward compatibility with the 1.8 branch, and is subject to major change until the first official 1.9.0 release

Master:

Develop:

File Formats supported

Reading

  • 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

Writing

  • BIFF 8 (.xls) Excel 95 and above
  • Office Open XML (.xlsx) Excel 2007 and above
  • HTML
  • CSV
  • PDF (using either the tcPDF, DomPDF or mPDF libraries, which need to be installed separately)

Requirements

  • PHP version 5.4.0 or higher
  • PHP extension php_zip enabled (required if you need PHPExcel to handle .xlsx .ods or .gnumeric files)
  • PHP extension php_xml enabled
  • PHP extension php_gd2 enabled (optional, but required for exact column width autocalculation)

Want to contribute?

If you would like to contribute, here are some notes and guidlines:

  • All new development happens on the 1.9 branch, so it is always the most up-to-date
  • The master branch only contains tagged releases
  • If you are going to be submitting a pull request, please fork from 1.9, and submit your pull request back to that 1.9 branch
  • Wherever possible, code changes should conform to PSR-2 standards
  • Helpful article about forking
  • Helpful article about pull requests

License

PHPExcel is licensed under LGPL (GNU LESSER GENERAL PUBLIC LICENSE)