Hi,
I'm having performance issues with PHPExcel when generating large files (tens of thousands of rows).
It takes a long time and uses a lot of memory.
I've played a little with the caching options but I'm still not quite satisfied with the results.
I've read that PHPExcel has open issues with memory management.
Does anyone know of a commercial Excel creation library?
thanks,
Jeremy
Generating Large Excel Files
Moderator: General Moderators
-
jeremyripley
- Forum Newbie
- Posts: 1
- Joined: Fri Jul 30, 2010 12:31 pm
Re: Generating Large Excel Files
I don't know of any commercial packages though I'm sure a google search will turn up something.
You could try converting to openOffice Calc and it should open in Office as well.
I assume you're just sticking numbers in columns and not putting in complex formulas (maybe a bad assumption).
You could also try breaking the process down in to several scripts and then just appending each piece to the end of the excel file. That might be a good work around. Just find a good balance of speed and performance.
You could try converting to openOffice Calc and it should open in Office as well.
I assume you're just sticking numbers in columns and not putting in complex formulas (maybe a bad assumption).
You could also try breaking the process down in to several scripts and then just appending each piece to the end of the excel file. That might be a good work around. Just find a good balance of speed and performance.