Re: Print MySQL DB as Exel File?

I know very little about php, but since you have already received a bunch of useless answers, I thought I add my guesswork. In php 4 you can access MS documents through Microsofts OLE interface. That means you can manipulate an .xls file as you would be able to in VisualBasic. You should look for something called COM in your documentation. I should add that I have never done it in php, only in perl... Goodluck -ren ----- Original Message ----- From: "Jeff Oien" <jeff@webdesigns1.com> To: "PHP" <php-general@lists.php.net> Sent: Thursday, March 15, 2001 10:25 AM Subject: [PHP] Print MySQL DB as Exel File? > Could anyone help me out with how to print the entire contents of a > database as an Excel file? I'm familiar with the header: > > header("Content-Type: application/vnd.ms-excel"); > > just not sure how to go about it beyond that. I have this code and > am not sure what do do after it. Thanks. > Jeff Oien > > while ($row = mysql_fetch_array($result)) { > $Event = $row['Event']; > $First_Name = $row['First_Name']; > $Last_Name = $row['Last_Name']; > $Title = $row['Title']; > $Organization = $row['Organization']; > $Phone = $row['Phone']; > $Email = $row['Email']; > $date = $row['date']; > $id = $row['id']; > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >