XLS Reader Feature Request

KNIME Analytics Platform
1

Hi,

If an Excel worksheet has rows or columns filtered or hidden, then when this worksheet is imported into the XLS Reader, these filtered or hidden rows/columns are not loaded.

Please can there be a checkbox to load all content regardless of hidden or filtered rows and columns.

Thanks,

Simon.

2

Has this feature been developed or is there a workaround solution to support this functionality?

Thanks,

Alex

3

I think hidden rows are always read, but for hidden columns you should pass "false" to the SKIP_HIDDEN_COLS flow variable.