natergj / excel4node

Node module to allow for easy Excel file creation
MIT License
1.38k stars 215 forks source link

Heap out of memory for a non-formatted, 100k row file #338

Open bfredo123 opened 3 years ago

bfredo123 commented 3 years ago

Describe the bug I get a heap out of memory error when executing the code below, producing and saving a basic 100k-row file. It happens when calling the write method.

To Reproduce https://gist.github.com/bfredo123/14a2b4f47bfcbdc83afb4748623b0fb3

Expected behavior It should just save the file succesfully.

Environment (please complete the following information):

Additional context I can make it work with setting max-old-space-size to 4GB, but it has to run on a 2GB machine, so this is not a good option for me.