If you really want to create Excel files directly from php, the attached file (untested) may help. I found this somewhere on the net while looking for the same solution. What I wound up using is the _excellent_ Spreadsheet::WriteExcel module for Perl. We simply call the perl CGI for that function of our web app. Works great! It also has a Spreadsheet::ParseExcel companion which works equally well. The only problem we had with this was not being able to get to the contents of the session while in Perl. Could have jumped through some hoops to get it, but wound up hacking around it by using a long query string with the pertinent parameters (ugly, but works). Al > -----Original Message----- > From: > [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]. > net] On Behalf Of Calin Rotaru > Sent: Tuesday, April 24, 2001 5:59 PM > To: Rahul Bhide; [EMAIL PROTECTED] > Subject: Re: [PHP] db to xls > > > You can query the oracle database and generate a text file > with tab delimiter. Then you can open this file in Excel. > > Calin > > On Tuesday 24 April 2001 10:31, Rahul Bhide wrote: > > Gurus, > > I want to query an oracle database and push the output to an MS > > Excel spreadsheet . Currently I am dumping it to a csv text > file and > > reading into Excel. > > Is there a better way to do this?? Is there a php function for > > this ?? Regards > > ~Rahul > > -- > 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]
