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.
Thanks!

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 …