A lot of issues working with Excel Reader on KNIME 5.5. Terrible new version! My workflow stopped...

Hi!

Today, I was surprised by issues with an old workflow that had been working really well. Until now, I have spent 4 hours working to fix it.

The problem is behaviour changes on the EXCEL READER node.

One of the files has a column NOTES with possible and the actual EXCEL READER stops during the process.

The workaround was to remove the lines with ‘n’ and consider how to handle them later.

However, it is worse.

When I opened the node to verify, it lost the configuration. As I’m not using all the Excel file columns, I need to unmark one by one the undesired columns.

This process is extremely slow because for each column, the node reprocesses the content list below the fields list. I tried reducing the number of lines read to 10, but it didn’t work. Still slow, and Excel has 62 columns! I need just 20.

This is absolutely frustrating.