Dump to file as comma separated and then load into Excel. Excel reads comma
separated files. In the file open dialog you can select file type to be .txt
(csv).
If you want to be really sick then you can set up an ODBC connection to a
comma separated file and then use MSQuery inside Excel.
Another alternative is to dump out your data to a webpage in an HTML table.
Excel can link to the web page, just goto to Data->Get External Data->New
Web Query. Select the URL and you're away. This is quite a cool feature as
you don't have to send out updated files on a continual basis.
Enjoy.
-----Original Message-----
From: Jorge Alvarez [mailto:[EMAIL PROTECTED]]
Sent: 13 July 2001 17:58
To: [EMAIL PROTECTED]
Subject: [PHP] Export to Excel
One of my clients is requesting me to export some data from PHP-generated
pages to MS Excel files. I have no clue on how to do such export with PHP.
I'm using PHP/Apache/Linux Mandrake.
What options do I have?
Your help is very appreciated.
Regards,
Jorge Alvarez
--
Let your screen saver contribute to cancer research.
http://members.ud.com/vypc/cancer/
A new way to help. Sponsored by Intel.
--
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]
