Create Excel 2007 Documents in PHP with PHPExcel

A set of PHP classes for writing to and reading from different file formats, like Excel, PDF and HTML. It supports many MS Excel features like adding worksheets to a spreadsheet, inserting data and formulas to cells, calculating formulas and much more. This project is built around Microsoft’s OpenXML standard and PHP.

PHPExcel 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

and a lot more....!