Cell Writing Limitation

Topics: Developer Forum, Project Management Forum, User Forum
Sep 16, 2010 at 3:31 PM


The PHPExcel version(1.7.0) i am using has limitation on the number of cells that can be written.

Has it been increased in the latest version of PHP excel?

The current limit is 1lac cells in 1.7.0

Sep 16, 2010 at 10:16 PM

I'm not aware of that limitation at all, in any version of PHPExcel. IIRC, 1 lac is 100,000. Can you point me to where this limit is enforced? If you can, I'll ensure that it is removed.

There are limits to the amount of memory that PHP can use (although these can be changed if your host permits); and PHPExcel can easily exceed this with large workbooks. But even without changing memory, PHPExcel can now work with larger workbooks (typically up to 3 times larger) with the changes that have been implemented since 1.7.0.

Alternatively, Excel has its own limits, and the PHPExcel Writers will prevent you writing more rows or columns than are permitted by the appropriate version of Excel. So the Excel5 Writer (for example) prevents you writing more than 65536 rows or 255 columns in any worksheet.