Re: Appending sheets to xlsx memory issues.
Rob Sargent <[email protected]>
| Newsgroups | gmane.comp.jakarta.poi.user |
|---|---|
| Message-ID | <[email protected]> |
> 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] >