+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11)
+--- Thread: Generating large Excel with Ci4 and PHPExcel (/showthread.php?tid=80483)
Generating large Excel with Ci4 and PHPExcel - hieuhiti - 11-07-2021
At the moment I'm using PHPExcel for export file, but After data above 5000 rows, the memory consumption and loading times become untolerable, and can't be solved by indefinitely increasing PHP's maximum limits for memory usage and script execution times.
In the future, the data can above 1 million rows. I need a good Solution for memory consumption.
Please help me,
RE: Generating large Excel with Ci4 and PHPExcel - John_Betong - 11-07-2021
I had memory problems when using PhpExcel and solved by liberally calling flush(); after small iterations.
RE: Generating large Excel with Ci4 and PHPExcel - wuuyun - 11-07-2021
one file split to some files , at last with zip files