Merging different sheets of a Excel Workbook into one.

[ipazin]

Hi there,

you can try giving more GBs to KNIME but still the underlying library of the Apache POI project performance is limited.

Check here:

Speed Up Reading Data / Heap Space

Hi all, Do you have any recommendations about how to avoid crashes and heap space exhaustion when reading input data, and how to read data in a faster way? First off, I’ve already gone through the usual material about heap space: changing the .ini file, changing the node’s memory policy, and closing all other applications. Even then, let me give you an example: I have an excel file that isn’t that big (30mb, it has 25 columns and 265,440 rows). My machine has 8GB RAM, and I’ve given 5GB to KNI…

Br,
Ivan