Excel Reader Poor Performance with Hidden Columns on v4.6.2

[AndrewDevlin]

As a follow up to this post:

KNIME 4.5.2 Excel Reader extremely Slow when reading from other sheet different than the first

Iam currently investigating what is the cause of this, on KNIME side as well as on Excel. What I found out is that if you display all columns (currently a lot of them are hidden) it reads the files very fast. So you could try to unhide all columns which can be quiet time consuming and annoying. Another workaround for the time being is to use XLS files instead of XLSX or use the option “Reevaluate formulas” in the Advanced settings tab if possible (here the file is treated as a XLS File). For the…

Is there any progress on the Excel reader performance issue with files with hidden columns or protection? File read times are SO long now. I have tried the settings changes in the above thread but they didn’t help me. I cannot un-protect the file or unhide the columns either.

Anything to report? Thanks!

[mlauber71]

@AndrewDevlin have you considered using a Python workaround in the meantime?

[laaaarsi]

Hey Andrew,

we resolved the issue with the hidden columns with the release coming next week

Best regards
Lars