Hi Rob, As you can see in the example I am appending data sheets in both cases (same random data)
On 2021/08/06 14:35:36, Rob Sargent <[email protected]> wrote: > > > > On Aug 6, 2021, at 3:44 AM, Moditha Hewasinghage > > <[email protected]> wrote: > > > > 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. > > > Are you adding empty sheets in the latter and large, with-data sheets(either > the existing or the appended) in the former? > > > Thank you, > > Regards > > Moditha > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [email protected] > > For additional commands, e-mail: [email protected] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
