How to set not read hide sheets

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.

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 ( Not very elegant indeed …

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.