Original Content

Office 2007 SpreadsheetML classes in PHP

In my evening hours, I've been working on a set of PHP classes to create Offixe 2007 SpreasheetML documents (.xlsx files). I finished my first goals (some basic XLSX writing), and I want to share this set of classes to the community.

Currently, the following features are supported:

  • Create a Spreadsheet object
  • Add one or more Worksheet objects
  • Add cells to Worksheet objects
  • Export Spreadsheet object to Excel 2007 OpenXML format

Each cell supports the following data formats: string, number, formula, boolean.

Visual formatting is not implemented, but I'll get to that later.

More information, an example XLSX file and source code can be found on my blog, http://www.balliauw.be/maarten/blog/24,office-2007-spreadsheetml-classes-in-php.htm

Published: December 14th, 2006 at 4:55
Categories: News

One comment to “Office 2007 SpreadsheetML classes in PHP”

Hi,

How about possibly contributing this work to the Zend Framework? File format support is definitely something we’d like to see there.
If you’re interested get in touch with me (andi at zend you know what).

Andi