Php com excell

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
leonardocdc
Forum Newbie
Posts: 3
Joined: Fri Jan 23, 2004 10:45 am

Php com excell

Post 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.
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post by JayBird »

are you running on a windows server?
leonardocdc
Forum Newbie
Posts: 3
Joined: Fri Jan 23, 2004 10:45 am

Post by leonardocdc »

No. It´s running in Linux Server
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post by JayBird »

Well, you can't use the COM functions on a Linux Server. Windows only i am afraid.

Mark
leonardocdc
Forum Newbie
Posts: 3
Joined: Fri Jan 23, 2004 10:45 am

Post by leonardocdc »

Ok Mark,

but you know other method to do this?

Thanks
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post by JayBird »

hedge
Forum Contributor
Posts: 234
Joined: Fri Aug 30, 2002 10:19 am
Location: Calgary, AB, Canada

Post 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/
jaxn
Forum Commoner
Posts: 55
Joined: Fri Jan 16, 2004 1:50 pm
Location: Nashville, TN

Post 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
Post Reply