Hello,
Every time I am using the node “excel-reader” my KNIME will start to lag. I need to close it through Task Manager. I have tried to uninstall and install it again, also used it in a new workflow however I am still facing the same issue.
I tried using other “reader” nodes such as csv, and file, both are working fine.
Only the excel reader has the issue.
Hello @amoralita,
and welcome to KNIME Community!
Is this same for every Excel file you try to read or only one specific? What is the location from which you read your files? What KNIME version are you using?
Br,
Ivan
@amoralita how large is your Excel file and how much RAM (memory) do have you assigned to KNIME?
If everything else fails, you can try and use in integrated Python module and Apache Arrow:
Hello @ipazin
I am using v5.8.1
For all excel reader, even if I tried to create new workflow. And I tried to have new node.
No, the node itself won’t work so I cannot choose file. Once i click the excel reader node then it will start to hang.
ok. I get it now. Never heard of that one. Might be something related to operating system but that is just a guess. If I were you I would try with some other KNIME version. Besides that you can check log file to see if there’s anything that can help you.
Br,
Ivan
@amoralita besides what I wrote earlier you can try and create a link to your Excel file by listing files and then providing the path to the Excel Reader as Path variable. That way you would avoid browsing. Are there many files in the location where your Excel file is? Is this a remote location? Did you check the memory in KNIME?
