Probably not exactly the answer that you're looking for, but you can do the
following. Output your data in PHP to a webpage that consists of purely a
table of your data. Open Excel, go to :
Data->Get External Data->New Web Query
Type in the URL for the page with your data.
Select which table you want to display (by name or number)
Click OK, and hey presto!
This spreadsheet can be saved, and anyone opening it can see the current
results of the data from the webpage.
-----Original Message-----
From: Ron [mailto:[EMAIL PROTECTED]]
Sent: 24 May 2001 15:51
To: [EMAIL PROTECTED]
Subject: [PHP] Excel
I was looking for a way to build a spreadsheet (Excel) dynamically with data
from a table, and I was curious about doing it in PHP .. I prefer to use
PHP, but I know in ASP it can be done. If I'm running PHP on Linux (can't
use the COM functions), is there a way this can be done? Preferably
starting with something like header("application/ms-excel...") or whatever
the mime is - dunno off the top of my head, and just writing data? If
there's no way to do this directly is it possible that by starting with this
header and then sending a csv (comma separated) text page that excel will
read it as a spreadsheet? Any help would be appreciated..
-Ron - [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]
--
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]
