Reading very large (over 100 MB) Excel files in PHP

Question

I am trying to read an Excel file larger than 100 MB using PHPExcel, but it crashes when the file is downloaded. I don't need a style. I tried using:

$objReader->setReadDataOnly(true);

but he still falls.

Is there an efficient way to read this excel file size in PHP?

Answer 1

Try Spout : https://github.com/box/spout .

This is a PHP library created to solve your problem (read / write large files). This is why it works:

, - . , .

, Spout . , , / . / ! :)