As a follow up to this post:
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!
@AndrewDevlin have you considered using a Python workaround in the meantime?
Hey Andrew,
we resolved the issue with the hidden columns with the release coming next week
Best regards
6 Likes
system
March 1, 2023, 8:37am
4
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
