Can't be done easily with PHP right now... To get that type of functionality, you'd need to write it in Perl using the SpreadSheet::WriteExcel module.
http://homepage.tinet.ie/~jmcnamara/perl/WriteExcel.html -----Original Message----- From: Brian Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:34 PM To: [EMAIL PROTECTED] Subject: [PHP] MySQL to Excel with mutiple sheets I have a script that searches a MySQL DB and produces an Excel file from each table in the search. EX. You search 4 different tables for the "Seattle" you would come up with 4 different Excel files. Now I was wondering if it was possible to take the 4 different Excel files I just created and combine into one excel file with 4 different sheets? If anyone has a code for this or could possible help me it would be great. I am using: PHP: 4.04 Linux: 7.0 MySQL: 3.22.32 Thanks -Brian _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
