How do you process large Excel files with phpexcel

113 Views Asked by At

When I try to read a large Excel file (106k rows, 24MB) my php script stops without any errors or warnings. I have drilled down to find out it halts at this specific statement:

$obj = PHPExcel_IOFactory::load($filename);

The manual shows no memory limitations so I don’t know how to fix this. Script works fine with smaller files but it’s clumsy having to break files into smaller ones just to process thru the script.

Appreciate any solutions/ pointers.

0

There are 0 best solutions below