theres an easy way if its a simple data table type spreadsheet your after, this works like a treat, at the top of your page that produces the data put -
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=\"file.xls\"");
remember that your sending headers here so they have to be the very first thing to be sent at the start of the page.
formatting will be maintained and it will basically produce whatever the table / s looked like in the html page, just like if you did a copy and paste from the web to excel.
-----Original Message-----
From: Christine Clerc [mailto:x.clerc@xxxxxxx]
Sent: 02 February 2004 10:03
To: PHP DB list
Subject: From MySQL to EXCEL
Hi,
I need to turn data extracted from MySQL into an EXCEL spreadsheet
(.xls, not a .txt that is imported into Excel).
Is it possible ?
Thank you.
Christine
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
