Generating Large Excel Files

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
jeremyripley
Forum Newbie
Posts: 1
Joined: Fri Jul 30, 2010 12:31 pm

Generating Large Excel Files

Post by jeremyripley »

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
JakeJ
Forum Regular
Posts: 675
Joined: Thu Dec 10, 2009 6:27 pm

Re: Generating Large Excel Files

Post by JakeJ »

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