ycTIN

PHPExcel is an powerful class for read & write excel files, it is very useful in the report generation. You can easily to use PHPExcel to create the true and new version excel files, not are outdated excel formats.

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

Quoted from PHPExcel homepage

Features

PHPExcel currently(v1.7) 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
  • Positioning
  • Rotation
  • Shadow
• Set printing options
  • Header
  • Footer
  • Page margins
  • Paper size
  • Orientation
  • Row and column breaks
  • Repeat rows at header / columns at left
  • Print area
• Output your spreadsheet object to different file formats
  • Excel 2007 (spreadsheetML)
  • BIFF8 (Excel 97 and higher)
  • PHPExcel Serialized Spreadsheet
  • CSV (Comma Separated Values)
  • HTML
  • PDF
• Read different file formats into your spreadsheet object
  • Excel 2007 (spreadsheetML)
  • BIFF5 (Excel 5.0 / Excel 95), BIFF8 (Excel 97 and higher)
  • PHPExcel Serialized Spreadsheet
  • Excel 2003 XML format
  • Symbolic Link (SYLK)
  • CSV (Comma Separated Values)
• … and lots of other things!

Homepage

http://www.phpexcel.net

Related posts:

1. [PHP] PHPMailer – The Mail Library The PHPMailer a powerful and most popular email transport class...
2. [PHP] Syntax Highlighter GeSHi started as an idea to create a generic syntax...
3. [PHP] jQuery PHP Edition? phpQuery! phpQuery is a server-side, chainable, CSS3 selector driven Document Object...
4. Open Flash Chart Why choose Open Flash Chart? This is a little gentle...
5. jQuery Overview jQuery is a fast and concise JavaScript Library that simplifies...