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" <[EMAIL PROTECTED]>
To: "PHP" <[EMAIL PROTECTED]>
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: [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]
