SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jun 2013
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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:

    HTML Code:
    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. #2
    Hosting Team Leader silver trophybronze trophy
    cpradio's Avatar
    Join Date
    Jun 2002
    Location
    Ohio
    Posts
    5,071
    Mentioned
    152 Post(s)
    Tagged
    0 Thread(s)
    Yep, either split the excel file into multiple files, or increase the memory limit in your php.ini
    Be sure to congratulate Patche on earning July's Member of the Month
    Go ahead and blame me, I still won't lose any sleep over it
    My Blog | My Technical Notes


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •