When saving a file with a lot of data in memory, the library simply goes into a loop and never finishes

[El-Tommy]

When I have more than 100K lines in the XLSX file, when trying to save to a file, more than 10 minutes pass and the file is not saved.

If there are few lines it saves quickly.

Will it be possible to save to a file while XLX is populated?
For example, every 500 lines, save to a file and dump the memory?

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="test_file.xlsx"');
header('Cache-Control: max-age=1');
$objWriter = IOFactory::createWriter($objPHPExcel, 'Xlsx');
$objWriter->save('php://output');
exit();