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.
Php com excell
Moderator: General Moderators
-
leonardocdc
- Forum Newbie
- Posts: 3
- Joined: Fri Jan 23, 2004 10:45 am
-
leonardocdc
- Forum Newbie
- Posts: 3
- Joined: Fri Jan 23, 2004 10:45 am
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/
http://search.cpan.org/~jmcnamara/Sprea ... xcel-0.39/
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
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