View Full Version : how to save the data in .xls using php?
PHPycho
01-13-2007, 02:42 AM
HI all
Saving the stored data in .html and .txt is simple. But i am looking for saving the data in excel without using pear.
Has anybody tried it out. If yes that would be very helpful to me .
Thanks in advance
whizard
01-13-2007, 02:56 AM
You could save into .CSV and import that into Excel...
Dan
PHPycho
01-13-2007, 03:56 AM
No i want to use using COM object. can anybody guide me?
Thanks
SpirtOfGrandeur
01-13-2007, 04:00 PM
What are you looking to do with the COM+ object?
PHPycho
01-13-2007, 10:04 PM
I have to save the data in simple format , there is no need of calculations and more..
Using pear may be a better idea, but that should be installed and that may be
a x-tra work to carry on. For simple format may be the COM application may be better.
Just i need is a good tutorial of .xls generation using COM objects and PHP.
Thanks in advance
SpirtOfGrandeur
01-13-2007, 10:40 PM
If all you want is simple stuff that opens in Excel then you don't need pear and you defiantly don't need COM+. All you need to do is print tables using inline styles. Then change the headers so that it changes to a download and make the file name end in an xls. The browser will ask the user if they want to open it in the xls file of choice...
If you need some examples I will be happy to get them to you.
vBulletin® v3.8.2, Copyright ©2000-2012, Jelsoft Enterprises Ltd.