如何从PHP中读取Excel文件（14MB +）中的大数据？

Question

How to read large data from Excel files (14MB+) in PHPExcel? I have done with excelreader it says Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 36 bytes) in E:\xampp\htdocs\Projects\PIN\library\excel_reader2.php on line 1508

can any one give me the link to read the excel large data?

Answer 1

Increase the memory php can use.

Edit php.ini and change the memory_limit option, for example:

memory_limit = 128M ; /* Change the 128M to your needs */

Also, read this related post: ini_set("memory_limit") in PHP 5.3.3 is not working at all