How to fix Fatal Error PHPExcel: Memory Limit Exhausted while reading XLSX file of 5M
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:
Can you please suggest me a solution to this problem?
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 32 bytes) in .....
Thanking you in anticipation.
Already Memory Limit Updated
Thanks for the reply. I have already tried the first solution i.e. changing memory_limit in php.ini But it stil does not work even setting the memory_limit= 512M.
Originally Posted by NogDog
However, I will look for the 2nd solution that you have just suggested using fopen() with CSV.
Looking forward. Hope to hear from you soon.