Hi Dominik, Yes I do have a loop of 100 just to see the failing point. Unfortunately it does not reach 100 iterations but fails after 3 (with 2GB memory). So I can have only 3 sheets in the "file" case. For "memory" I can have 10 sheets.
Moditha On 2021/08/11 08:30:44, Dominik Stadler <[email protected]> wrote: > 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] > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
