Jump to content


Photo

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

php

  • Please log in to reply
2 replies to this topic

#1 RaoRafique

RaoRafique

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 18 June 2013 - 01:47 PM

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.



#2 xenLiam

xenLiam

    Advanced Member

  • Members
  • PipPipPip
  • 43 posts
  • LocationManila
  • Age:16

Posted 20 June 2013 - 11:13 PM

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


Lives by faith, thinks by logic.


#3 PravinS

PravinS

    Advanced Member

  • Members
  • PipPipPip
  • 404 posts
  • LocationNashik, India

Posted 20 June 2013 - 11:22 PM

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

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

Thanks & Regards,
PravinS | Blog





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com