RaoRafique Posted June 18, 2013 Share Posted June 18, 2013 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. Quote Link to comment https://forums.phpfreaks.com/topic/279325-how-to-fix-fatal-error-phpexcel-memory-limit-exhausted-while-reading-xlsx-file-of-5m/ Share on other sites More sharing options...
xenLiam Posted June 21, 2013 Share Posted June 21, 2013 Increase the value of memory_limit in php.ini to something like 128MB or 384MB. Quote Link to comment https://forums.phpfreaks.com/topic/279325-how-to-fix-fatal-error-phpexcel-memory-limit-exhausted-while-reading-xlsx-file-of-5m/#findComment-1437156 Share on other sites More sharing options...
PravinS Posted June 21, 2013 Share Posted June 21, 2013 you can also set memory limit using ini_set function on that page like this ini_set("memory_limit","256M"); Quote Link to comment https://forums.phpfreaks.com/topic/279325-how-to-fix-fatal-error-phpexcel-memory-limit-exhausted-while-reading-xlsx-file-of-5m/#findComment-1437157 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.