[PHP] Generating an Excel file?
I'm pretty sure I know how to use header() create a CSV file for a client to download data from a database, but I think it would really impress this client if I could generate a Microsoft Excel file instead of a CSV file. Anyone know how to do this? -Ben -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Generating an Excel file?
Google is your friend ;-) -J -Original Message- From: Ben Ramsey [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 5:41 PM To: [EMAIL PROTECTED] Subject: [PHP] Generating an Excel file? I'm pretty sure I know how to use header() create a CSV file for a client to download data from a database, but I think it would really impress this client if I could generate a Microsoft Excel file instead of a CSV file. Anyone know how to do this? -Ben -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Generating an Excel file?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ben Ramsey wrote: | I'm pretty sure I know how to use header() create a CSV file for a | client to download data from a database, but I think it would really | impress this client if I could generate a Microsoft Excel file instead | of a CSV file. Anyone know how to do this? We get this request from clients at work quite often. Most people don't realize .csv files are Excel friendly. Just make the data comma delimited and name it .csv. It'll work. - -- ** * ____ _ * * ___/ /__ ___ / /_(_)__ ___ __ __ ___ __ _ * * / _ / -_)_-/ __/ / _ \/ -_) // // __/ _ \/ ' \ * * \_,_/\__/___/\__/_/_//_/\__/\_, (_)__/\___/_/_/_/ * *(___/ [EMAIL PROTECTED] * ** BOFH Excuse #269: Melting hard drives -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFADG+HoAq8t3CabwcRAm3eAJ48cC3E6+Mh5HezwKKIsvflAe62dACfUfE/ jFqr+KcMIUsEG2Hw/rCuUKA= =8jBi -END PGP SIGNATURE- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Generating an Excel file?
Geez what really bad advice, giving an end user a totally useless unfriendly csv file is bad bad bad. I suggest you check out http://pear.php.net/package/Spreadsheet_Excel_Writer , its a pain to get the layout perfect, but once its done you have what you need. I've also been trying to hassle to get a report server installed and working check out either Datavision or Report Manager, it took me less than an hour to design the report. It took me 2 months to try and get the systems guy to install it but still not happening due to the fact its delphi/kylix database drivers which just are not so friendly as JDBC and the RM developer is not so friendly with support but its the only most decent open source alternative out there, you could also check out ICrystal. -Original Message- From: Ben Ramsey [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 5:41 PM To: [EMAIL PROTECTED] Subject: [PHP] Generating an Excel file? I'm pretty sure I know how to use header() create a CSV file for a client to download data from a database, but I think it would really impress this client if I could generate a Microsoft Excel file instead of a CSV file. Anyone know how to do this? -Ben -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php