PHPExcel – OpenXML – Create Excel2007 documents in PHP
Project providing a set of classes for the PHP programming language, which allow you to write to and read from different file formats, like Excel 2007, PDF, HTML, ... This project is built around Microsoft's OpenXML standard and PHP.
Checkout the Features this class set provides, such as setting spreadsheet meta data (author, title, description, ...), multiple worksheets, different fonts and font styles, cell borders, fills, gradients, adding images to your spreadsheet and much, much more!
PHPExcel currently features:
* Create an in-memory spreadsheet representation
* Set spreadsheet meta data (author, title, description, ...)
* Add worksheets to spreadsheet
* Add data and formulas to individual cells
* Merge cells
* Protect ranges of cells with a password
* Supports setting cell width and height
* Supports different fonts and font styles
* Supports formatting, styles, cell borders, fills, gradients, ...
* Supports hyperlinks
* Supports different data types for individual cells
* Supports cell text wrapping
* Supports conditional formatting
* Supports column auto-sizing
* Supports rich-text strings
* Supports autofilter
* Supports "freezing" cell panes
* Supports cell-level security
* Supports workbook-level security
* Supports worksheet-level protection
* Group rows/columns
* Cell data validation
* Insert/remove rows/columns
* Named ranges
* Worksheet references
* Calculate formula values
* Add comments to a cell
* Add images to your spreadsheet
* Set image styles
o Positioning
o Rotation
o Shadow
* Set printing options
o Header
o Footer
o Page margins
o Paper size
o Orientation
o Row and column breaks
o Repeat rows at header / columns at left
o Print area
* Output your spreadsheet object to different file formats
o Excel 2007 (spreadsheetML)
o BIFF8 (Excel 97 and higher)
o PHPExcel Serialized Spreadsheet
o CSV (Comma Separated Values)
o HTML
o PDF
* Read different file formats into your spreadsheet object
o Excel 2007 (spreadsheetML)
o BIFF5 (Excel 5.0 / Excel 95), BIFF8 (Excel 97 and higher)
o PHPExcel Serialized Spreadsheet
o Excel 2003 XML format
o Symbolic Link (SYLK)
o CSV (Comma Separated Values)
* ... and lots of other things!