Hi Knime experts
I have some files need be read, and each file has some hide sheets, when I use node read excel sheet names, all sheets including hide sheets are read.
I don’t want read those hide sheets, anyway to help me do this.
Thanks!
1 Like
Hi @Chenfang
It appears this still isn’t a feature.
1 Like
@ArjenEX Thanks for your reply! Hope Knime experts team can add this function near future.
1 Like
@Chenfang you could use OpenPyxl and a Python Node to check which sheets are hidden and then exclude them from the import (https://kni.me/n/pSZxsfdYwqHb7ecJ). Not very elegant indeed …
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.