How to write huge amount of data to xls file?

Question

excel

Good day. There is a huge array of data - 1 million objects, which are obtained by sampling from the database. Now all this needs to be written into an excel file.
First I took the excel4node npm package. For small datasets, it is great (like many others, by the way). Support for styles, formatting, cell reversal, etc. But as soon as I tried to write these same 1 million lines, the node crashed with:

FATAL ERROR: Ineffective mark-compacts near heap limit Allocation failed - JavaScript heap out of memory

.
If it was a regular file, I would use streams for asynchronous recording, but what about the xls file exactly?

Answer 1

Well, according to the word node stream to xls, packages like this are
googled
.
Excel by itself will be able to open a million lines?