Monday, 26 February 2007

Try Out the New PHPExcel Version 1.0.0

Maartenba over at the Zend Developer Zone, informs you about version 1.0.0 of PHPExcel. He says that this version is a set of classes that allows you to write Excel 2007 files from PHP.

He informs you that the class set currently supports features such as setting spreadsheet meta data like author, title, description, multiple worksheets, different fonts and font styles, cell borders, fills, gradients, adding images to your spreadsheet, conditional formatting. He further informs that the team is working on a Reader for Excel2007 files too.

The web site gives the following features of PHPExcel v 1.0.0:

• Create an in-memory spreadsheet representation
• Set spreadsheet meta data (author, title, description,)
• Add worksheets to spreadsheet
• Add data and formulas to individual cells
• Supports setting cell width and height
• Supports different fonts and font styles
• Supports formatting, styles, cell borders, fills, gradients
• Supports different data types for individual cells
• Supports conditional formatting
• Add images to your spreadsheet
• Set printing options