Re: [PHP-DB] From MySQL to EXCEL

2004-02-02 Thread Nitin Mehta
use simple export command select * into 'name.xls' from 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 dat

Re: [PHP-DB] From MySQL to EXCEL

2004-02-02 Thread Ignatius Reilly
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

RE: [PHP-DB] From MySQL to EXCEL

2004-02-02 Thread Griffiths, Daniel
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