I've finally gotten around to releasing v1.0 of the php-excel extension, the list of changes for this release is quite substantial:
* Fixed issue #63 writing for NULL values using writeRow()
* Added excel.skip_empty INI setting that allows null values to be skipped, if set to 2 the empty strings will be skipped as well
* Added Sheet::setRightToLeft() and Sheet::setRightToLeft() methods that specifies whether the sheet in is "right to left" display mode
* Added Book::isTemplate() and Book::setTemplate() methods for detecting xltx files and converting from xlsx to xltx and vice versa
* Fixed compilation with LibXL 3.5.4
* Added optional scope parameter to setNamedRange()/delNamedRange()/getNamedRange() methods
* Updated getNamedRange()/getIndexRange() methods to retrieve hidden state
* Added parameter to readRow/readCol/read methods that specifiy whether to parse formula or its value.
* Added ExcelBook::packDateValues() method for generating Excel date value
* Added ExcelBook::setPrintArea() method for setting print area
* Fixed parsing of non-numeric formulas inside read() method
* Fixed parameter processing inside ExcelSheet::getVerPageBreak()/getHorPageBreak() methods
* Fixed parameter order inside ExcelSheet::getNamedRange()/getIndexRange() methods
* Fixed return value processing inside ExcelBook::setActiveSheet() method
- Added ExcelBook::IsDate1904/ExcelBook::ISetDate1904 methods to set/retrieve base date format
- Allow compilation against LibXL 3.5.3
- Fixed bug with parameter order inside setNamedRange method (jacksonja)
I've just released a new version of Excel extension for PHP, v0.9.8. The main purpose of this release is to add compatibility for libxl 3.4. From the library ChangeLog there appear to be quite a few fixes to the library, so it looks like a worth while upgrade for most users.
You can download the tarball at http://ilia.ws/patch/php-excel-0.9.8.tar.bz2.
Sources are available at https://github.com/iliaal/php_excel/.
I've recently started work on porting our internal company PHP patches over to PHP 5.4 as part of our migration from 5.3 to 5.4 One of those patches is the type-hint patch that introduces scalar type hints to PHP (something I wrote originally for PHP 5.1), something that was briefly included in PHP 5.4 but then (unfortunately) reverted.
Since I feel that type-hints is a pretty handy feature to have as it eliminates many possible errors, improves code interrogation and addresses some of the limitations currently being worked-around via annotations I've decided to share this patch with the community. The patch is available for download at: http://ilia.ws/patch/php54_type_hints.txt it applies cleanly against PHP 5.4.8 as well as 5.4 branch (5.4.9RC1). I suspect it will work with earlier versions of PHP 5.4 as well. The patch includes full test coverage around the new functionality and all of the existing tests continue to pass (so nothing is broken).