How to fix Fatal Error PHPExcel: Memory Limit Exhausted while reading XLSX file of 5M

[RaoRafique]

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

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.

[xenLiam]

Increase the value of memory_limit in php.ini to something like 128MB or 384MB.

[PravinS]

you can also set memory limit using ini_set function on that page like this

ini_set("memory_limit","256M");