Appending sheets to xlsx memory issues.

Hi everyone,

I am trying to append a sheet into an existing xlsx and encountering memory issues. However, If I do not open an existing xlsx I can write far bigger files. I have an example code snippet here:

https://snippet.host/epsv

With 2GB of memory I only manage to append 3 sheets before I run out of memory in wb.write().

But I can easily create a new workbook and append 10 sheets without any issue. Could you please tell me if I am doing a mistake somewhere or if there is an alternative for this.

Thank you,
Regards
Moditha