HI everyone, I am trying to read an excel with around 100 Columns and 400K Rows (file size around 160MB), however, the excel reader dont allow me to proceed, and say “Requested array size exceeds VM limit”. In my KNIME.ini, i have make change of below. -Xmx12g (revised to 12g, while my computer has 16g) -Dknime.database.fetchsize=1000 (Newly added) If there is no direct way to deal with that, do we have some play around trick please? All i want is to read this file (5 more files at similar sizes), filter by a string at certain column, extract those and append to form a new file. Thanks in advance

[Excel reader node] Requested array size exceeds VM limit

mlauber71 November 24, 2021, 1:29pm 18

@Fovas another thing to try could be to use R’s “openxlsx” package:

"invalid code lengths set" on Excel Reader