[PHP-DB] From MySQL to EXCEL
Hi, I need to turn data extracted from MySQL into an EXCEL spreadsheet (.xls, not a .txt that is imported into Excel). Is it possible ? Thank you. Christine -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] From MySQL to EXCEL
theres an easy way if its a simple data table type spreadsheet your after, this works like a treat, at the top of your page that produces the data put - header(Content-Type: application/vnd.ms-excel); header(Content-Disposition: attachment; filename=\file.xls\); remember that your sending headers here so they have to be the very first thing to be sent at the start of the page. formatting will be maintained and it will basically produce whatever the table / s looked like in the html page, just like if you did a copy and paste from the web to excel. -Original Message- From: Christine Clerc [mailto:[EMAIL PROTECTED] Sent: 02 February 2004 10:03 To: PHP DB list Subject: [PHP-DB] From MySQL to EXCEL Hi, I need to turn data extracted from MySQL into an EXCEL spreadsheet (.xls, not a .txt that is imported into Excel). Is it possible ? Thank you. Christine -- 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] From MySQL to EXCEL
C'est possible! I use the PEAR Spreadsheet_Excel_Writer for this purpose. Very nice. HTH Ignatius _ - Original Message - From: Christine Clerc [EMAIL PROTECTED] To: PHP DB list [EMAIL PROTECTED] Sent: Monday, February 02, 2004 11:02 Subject: [PHP-DB] From MySQL to EXCEL Hi, I need to turn data extracted from MySQL into an EXCEL spreadsheet (.xls, not a .txt that is imported into Excel). Is it possible ? Thank you. Christine -- 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] From MySQL to EXCEL
use simple export command select * into 'name.xls' from table name It should help Nitin - Original Message - From: Christine Clerc [EMAIL PROTECTED] To: PHP DB list [EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:32 PM Subject: [PHP-DB] From MySQL to EXCEL Hi, I need to turn data extracted from MySQL into an EXCEL spreadsheet (.xls, not a .txt that is imported into Excel). Is it possible ? Thank you. Christine -- 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