There is not an easy way that I know of, however, you do have some alternatives. I believe outputting data in html tables and setting the content-type and name properly will work. This is somewhat messy and doesn't allow you to do much with the data, however. Another method I have used and the best way I found to do it was to write the data in xml format. I don't know if there is any good documentation for that, but if you save a spreadsheet as a web page from excel, you should be able to reverse engineer what you need from that. By using xml, you can also specify a lot of things you otherwise wouldn't be able to such as column width, print size, and more.
Good luck, and feel free to let me know if you need more detailed info. isetro On Tue, Apr 01, 2003 at 04:58:20PM -0500, Chris and Trish Kaelin wrote: > 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
