java heap error when using write to excel template node

[mlauber71]

@Heinz

Is there a way to relase the java heap memory?

There is the Garbage Collection. More performance hints:

Mastering KNIME: Unlocking Peak Performance with Expert Tips and Smart Settings

@Heinz

Is there a better way to write to excel

Not sure if it is better but you can use OpenPyxl to append data to an existing excel sheet.

Data extraction from .xls file/s

@Matt9301 there is a way to do this with the use of Python pandas and openpyxl [image] You would have to provide an existing excel file and a sheet name and then sheets with the same structure. [image]

And I assume it is necessary to write to a template to preserve the formats? Or would it be possible to write to a blank sheet and add the formats later?