RE: [PHP-DB] PHP Classes to generate Excel files ?
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 [EMAIL PROTECTED] To: 'PHP DB' php-db@lists.php.net Subject: [PHP-DB] 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
Re: [PHP-DB] PHP Classes to generate Excel files ?
Le 22 déc. 04, à 15:12, Bastien Koert a écrit : Don't really need a class...simply output a csv file with the correct headers...and excel knows to open the csv files Yes but this way you can't get a minimum of customization features (styles, borders, colors...etc). XML Excel format can handle that. So I was looking for such a PHP solution Thanks. Stéphane -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP Classes to generate Excel files ?
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 [EMAIL PROTECTED] To: 'PHP DB' php-db@lists.php.net Subject: [PHP-DB] 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 [EMAIL PROTECTED] To: 'PHP DB' php-db@lists.php.net Subject: [PHP-DB] 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
Re: RE: [PHP-DB] PHP Classes to generate Excel files ?
From: Bastien Koert [EMAIL PROTECTED] Don't really need a class...simply output a csv file with the correct headers...and excel knows to open the csv files It can even be an HTML table send with Excel headers and it'll open correctly. That's the easiest way, IMO, because you can include styling along with it. ---John Holmes... UCCASS - PHP Survey System http://www.bigredspark.com/survey.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP Classes to generate Excel files ?
From: Stéphane Pinel [EMAIL PROTECTED] 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...). http://www.web-aware.com/biff/ This has been around quite a while. I don't if it's still being actively developed or kept up to date or what, though... ---John Holmes... UCCASS - PHP Survey System http://www.bigredspark.com/survey.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP Classes to generate Excel files ?
There is also the very good PEAR Excel Writer class. http://pear.php.net/package/Spreadsheet_Excel_Writer Ignatius - Original Message - From: John Holmes [EMAIL PROTECTED] To: Stéphane Pinel [EMAIL PROTECTED]; 'PHP DB' php-db@lists.php.net Sent: 22 December 2004 20:54 Subject: Re: [PHP-DB] PHP Classes to generate Excel files ? From: Stéphane Pinel [EMAIL PROTECTED] 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...). http://www.web-aware.com/biff/ This has been around quite a while. I don't if it's still being actively developed or kept up to date or what, though... ---John Holmes... UCCASS - PHP Survey System http://www.bigredspark.com/survey.html -- 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
