How to set not read hide sheets

KNIME Analytics Platform
1

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
2

Hi @Chenfang

It appears this still isn’t a feature.

1 Like
3

@ArjenEX Thanks for your reply! Hope Knime experts team can add this function near future.

1 Like
4

@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 …

5

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