It is required to generate a price list, about 40k lines. It is important to have the ability to group lines to create a tree, support older versions of Excel (2003 and higher), speed and reasonable memory consumption.

I tried PHPexcel, it does everything it needs, but it requires a lot of memory, and it takes a long time (9 files are generated about 9 minutes)

I tried Spreadsheet_Excel_Writer (PEAR), it works fast and eats 30 MB of memory, but there is no possibility to group lines. (Maybe I could not figure it out? If you tell me how it will be cool).

If this is important, php 7.0.27, CentOS Linux release 7.4.1708

Thank.

0