if your running it on a windows box with excel installed, then you can use a COM object and export directly to an Excel (.xls) file. i've done this, and can supply some cool codes if needed.
this stuff is pretty simple, and very cool when you get it working. another alternative is to export in comma seperated file which doesn't require any addon's, and a .csv file will drop straight into excel with no real problems. if you want some COM code pointers tho and it's an option for your server, give me a shout and i'll post what i've written... ----- Original Message ----- From: "Chris and Trish Kaelin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 01, 2003 10:58 PM Subject: [PHP-WIN] Output to Excel File > At my job, we are using ColdFusion with an Oracle database, and one the > things we do is output data in a HTML table using contentType = > "application/msexcel", which creates a MS Excel spreadsheet. > > The two web sites I am running from home are PHP with an mySQL database. Is > there a similar method in PHP ot create a MS Excel spreadsheet? > > Chris Kaelin > > _________________________________________________________________ > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > http://join.msn.com/?page=features/virus > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
