What is the max Excel file size PHPExcel can support

Topics: Developer Forum, Project Management Forum, User Forum
May 2, 2012 at 10:34 PM

I'm going to use it to do offline export of a very large file (~8 MB).

I'm not too concern if it would take few seconds vs. few minutes, but I would like to know if it is possible.

Thanks

Coordinator
May 2, 2012 at 11:31 PM
Edited May 2, 2012 at 11:34 PM

That all depends on PHP memory settings, caching methods, size of content (number of sheets, cells, strings in cells, rich text content), amount of formatting and whether it's cell or row/column level formatting, number of styles, use of features such as conditional formatting, whether you want to read, write or both (and what formats) and is almost impossible to answer.

My rule of thumb is 1k/cell (1.6k/cell on 64-bit PHP) without caching; but the only real way to find out is to try and see, although the caching table in this thread might help.

May 3, 2012 at 8:06 AM
Edited May 3, 2012 at 8:07 AM

In the past I've been able to generate worksheets with about 150K rows, and 10-20 columns. That was about the limit of my setup (which had 24GB of memory at the time).  Layout was relatively simple, but the amount of data was rather huge. This causes PHPExcel to use a lot of memory, as the architecture demands all data to be resident in memory.

 

Please note though, that generation of this size of worksheets may take hours rather than minutes or seconds ;)