Page 1 of 1
Php com excell
Posted: Fri Jan 23, 2004 10:45 am
by leonardocdc
Hello for all,
well, i need help. In my site, i want open th excell, write in new document, save and close. For this i need the COM functions. But this functions are php for windows. Can i do this different mode?
Somebody have a one example?
Ps: Sorry my bad english.
Posted: Fri Jan 23, 2004 11:01 am
by JayBird
are you running on a windows server?
Posted: Fri Jan 23, 2004 12:08 pm
by leonardocdc
No. It´s running in Linux Server
Posted: Fri Jan 23, 2004 12:18 pm
by JayBird
Well, you can't use the COM functions on a Linux Server. Windows only i am afraid.
Mark
Posted: Mon Jan 26, 2004 6:09 am
by leonardocdc
Ok Mark,
but you know other method to do this?
Thanks
Posted: Mon Jan 26, 2004 9:15 am
by JayBird
Posted: Mon Jan 26, 2004 12:12 pm
by hedge
This is a lib using perl, I have always considered converting it to php but haven't. I am unfamiliar with perl but maybe you can use it from php somehow.
http://search.cpan.org/~jmcnamara/Sprea ... xcel-0.39/
Posted: Mon Jan 26, 2004 1:04 pm
by jaxn
That package has already been ported to PHP (it is in PEAR):
http://pear.php.net/package/Spreadsheet_Excel_Writer
It works well for me, but I am just using it for an export that could be done as a comma seperated file as well (I provide both for user choice).
My experience is that the PEAR package works well, but that you cannot write spreadsheets larger than approx 65,000 rows.
I have used it to create workbooks with multiple spreadsheets as well, and that worked for me too.
I do not know if you can use formulas within the spreadsheets.
HTH,
-Jackson