exceljs giving out of memory in writeBuffer method

Question

I'm tring to use writeBuffer method but it is giving me, Reached heap limit Allocation failed error. It is working on small excel but giving an error on big ones. Is there any solution you know? I'm using exceljs.

const fileAsBuffer = await workbook.xlsx.writeBuffer(); // giving out of memory error

Answer 1

It would be nice if you could give us a little bit more information about the execution environment first. The issue, most likely, appears due to the strict standard limit for memory usage in V8, but first check this

Try to read this: https://github.com/exceljs/exceljs/issues/2041