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....!

Visit the PHPExcel website at http://www.phpexcel.net/ for download instructions and more details.

Article ID: 575
Created: Wed, Jul 14, 2010
Last Updated: Sat, Jul 17, 2010
Author: Administrator

Online URL: https://www.articlediary.com/article/create-excel-2007-documents-in-php-with-phpexcel-575.html