This project includes some classes which are used to generate very simple MS Excel file (xls) via PHP. The generated xls file can be obtained by web as a stream file or can be written under $default_dir path. It has very simple usage to generate xls file from a select query using mysql, pgsql, oci8 databases.
Limitation:
– Max character size of a text(label) cell is 255
( due to MS Excel 5.0 Binary File Format definition )
Give it a try here
May 12th, 2002 at 1:14 am
this seems to be an extension of the same idea: http://freshmeat.net/releases/83898/
September 27th, 2002 at 7:55 am
Another class has been developed to manipulate Excel files.
Description:
Class for generating Excel files, based on John McNamara\’sSpreadsheet::WriteExcel from CPAN.
It supports all the basic values for cells.
It doesn\’t support URLs, images (working on it) and charts. It has very asic support for formulas.
Give it a try at http://phpclasses.byting.at/browse.html/package/767.html
December 7th, 2003 at 4:40 am
a nice little trick with PHP is if you need quick and easy content outputted to the excel file format, you just markup what you need in html, and send it with excel headers.
see this code for an example.