[Answered ]-Xlsxwriter consuming too much memory and process gets killed

I’ve tried with a parameter called constant_memory but it doesn’t seem to make a difference.

It should do. As shown in the XlsxWriter Documentation the constant_memory option keeps the memory usage constant and small.

So if it doesn’t make a difference to your application then maybe the issue isn’t with XlsxWriter and something else is consuming the memory.

Can you verify that by commenting out all calls to worksheet.write() and running the test again.