Generating large Excel with Ci4 and PHPExcel

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,

I had memory problems when using PhpExcel and solved by liberally calling flush(); after small iterations.

one file split to some files , at last with zip files