RE: [PHP] Excel

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:ron_pa@hotmail.com] Sent: 24 May 2001 15:51 To: php-general@lists.php.net 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 - ron_pa@hotmail.com -- 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