Didn't take a very close look, but it seems for the "file" case you run a loop of 100 and continually overwrite the file with the enlarged one and thus you add more and more sheets over time to the file. For "memory" you do it differently with a loop of 10 and thus there is much less data in the resulting workbook, or?
Dominik. On Sat, Aug 7, 2021 at 9:21 PM Moditha Hewasinghage < [email protected]> wrote: > 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] > >
