Re: Appending sheets to xlsx memory issues.

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]
> 
>