How to fix Fatal Error: Memory Limit Exhausted while reading XLSX file of 5MB or Higher

Topics: Developer Forum, Project Management Forum, User Forum
Jun 18, 2013 at 11:53 AM

I am facing this problem while reading an XLSX files having 40,000 plus rows and 7 columns having 5MB+ file size.

The error description is given here:

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 32 bytes) in

Can you please suggest me a solution to this problem?

Thanking you in anticipation.

Best Regards,
Rao Rafique.
Jun 18, 2013 at 12:36 PM
Either increase your PHP memory, or use one of the documented techniques such as cell caching to reduce memory requirements.... this is all documented, and searching the questions here on the board will show other techniques that you can use