Increased Excel file size and Excel Writer sheet append issue with KNIME 4.6.0

Hi everyone,

this is indeed the same topic as the closed one here:

Hi, Hope everyone is doing well! I updated my KNIME to 4.3.1 recently. I started replacing legacy nodes with the new ones, and started from Excel Writer nodes. I really liked the new nodes. I am collecting information from multiple places and combining all information in one Excel file using append under file and overwrite under sheet name options. The final file has 4 sheets; sheet 1 has up to 10 rows sheet 2 has up to 15 rows sheet 3 has up to 50 rows sheet 4 has 200k rows Previously whe…

I didn’s see a real solution in it, that’s why I’m opening this topic again.

So I have this issue with KNIME 4.6.0 and I am wondering, if a real solution has been found.

My issue

The workflow creates several tables which are then written down to excel. Ideally it should be one Excel file with several Worksheets. The problem occurs with appending new Sheets to an existing Excel file which always runs into Java heap Error.

On my computer there is no issue, on the computer of my customer I run into Java Heap Error.

Troubleshooting so far

1.

Checked RAM and allocated RAM on the customers computer and upgraded it so my customer has same amout of RAM allocated to KNIME. Issue still there.

1.

Originally, the workflow was created with KNIME 4.3.5 so I thought upgrading will help. After upgrading to 4.6.0 and replacing the depercated Join nodes, been facing the same issue.

1.

If I write each sheet to a separate Excel file, it works. The created files are however larger than they should be (like 100 MB instead of 10 MB for the first sheet, the other ones are ok, like 100 KB). Their size reduces to normal if I open them and save them (?!). Maybe it does have something with the columns of type number to do?

Is there anything I’m missing? What else can I do?