[nflug] PHP Excel File Class

[Mike Richardson]

Justin Bennett wrote:
> I'm looking for a class for PHP that will allow me to create native
> Excel documents as streaming output. I'm using CSV now, but It's
> beginning to be a pain with leading zero's and such.
> 
>    I've seem Biffwritter, It states I need to install the Zend Optimizer
> (I assume it's compiled PHP), that's not really my preference. I'm not
> really looking to mess with a COM interface.

Justin (and others),

	We've started to play with php_writeexcel, which is an almost complete
port of the Perl Spreadsheet::WriteExcel module. The doc for the PHP
version is severely lacking, but for the most part the CPAN doc is
accurate (I've discovered a few of the missing functions via
trial-and-error). Just realize that this software generates Excel v.5
binary .xls files.

php_writeexcel homepage:
http://www.bettina-attack.de/jonny/view.php/projects/php_writeexcel/

Spreadsheet::WriteExcel on CPAN:
http://cpan.uwinnipeg.ca/dist/Spreadsheet-WriteExcel

There's another package that generates XML-formatted spreadsheets, but I
haven't tried it at all - mainly because php_writeexcel has all the
functionality I needed for my projects.

One of the biggest problems I ran into using this program involved
Internet Explorer and corrupted header handling when sessions were
involved. If you need any help with getting around it, let me know.

Hope that helps!

-- 
Michael Richardson
Web Programmer, ePharmacotherapy Networks
School of Pharmacy and Pharmaceutical Sciences
State Univ. of New York at Buffalo
Cooke Hall Room 309
(716)645-2828 ext. 266

_______________________________________________
nflug mailing list
nflug at nflug.org
http://www.nflug.org/mailman/listinfo/nflug