try googling on
'php excelwriter'
or
'php excel writer'
if you require more than basic CVS (hint PEAR contains a class design to generate functionally rich XLS files).
----
another cool trick (which Bastien hinted at) is to output the correct headers so that IE (its IE only i'm afraid) will start up an Excel session in the browser window.... all you have to do is output an arbitrary HTML table of data
and excel will convert it for you on the fly.
a quick google led me to this article which will probably give enough info to get started:
http://www.evolt.org/article/Using_MySQL_and_PHP_to_Present_Excel_Spreadsheets/20/26896/
Bastien Koert wrote: > Don't really need a class...simply output a csv file with the correct > headers...and excel knows to open the csv files > > bastien > >> From: Stéphane Pinel <spinel@xxxxxxxxxxxx> >> To: "'PHP DB'" <php-db@xxxxxxxxxxxxx> >> Subject: PHP Classes to generate Excel files ? >> Date: Wed, 22 Dec 2004 14:19:41 +0100 >> >> Hello, >> >> I'm looking for PHP classes (free or cheap) that are able to generate >> Excel files (XML?) with a minimum >> of customization capabilities (styles, borders, colors...). >> >> Any idea ? >> >> Thanks in advance. >> >> Stéphane >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >
Bastien Koert wrote:
Don't really need a class...simply output a csv file with the correct headers...and excel knows to open the csv files
bastien
From: Stéphane Pinel <spinel@xxxxxxxxxxxx> To: "'PHP DB'" <php-db@xxxxxxxxxxxxx> Subject: PHP Classes to generate Excel files ? Date: Wed, 22 Dec 2004 14:19:41 +0100
Hello,
I'm looking for PHP classes (free or cheap) that are able to generate Excel files (XML?) with a minimum
of customization capabilities (styles, borders, colors...).
Any idea ?
Thanks in advance.
Stéphane -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
