How to import Excel files that are larger than 10,000 lines as soon as PHP

There is currently an Excel file greater than 10,000 lines, a total of 100 columns, with Phpexcel when the memory is always overflow, and very slow. Is there no other good way? To solve!

Reply content:

There is currently an Excel file greater than 10,000 lines, a total of 100 columns, with Phpexcel when the memory is always overflow, and very slow. Is there no other good way? To solve!

I've dealt with these issues before:
1. Paging export, 200 rows each, that is, 200 records per page;
2. When the export is complete, the front-end form will increase the page number by 1 and continue exporting until the 5th page is finished exporting.

Focus on "PHP technology Daquan" public number (Phpgod), pick up the phone, open, easy to sweep the following QR code, grow a little every day, the achievement of the great God is not far.

http://www.zhihu.com/question/26528899

