Read Specific Excel Sheets - Wildcard

[mmngeoh]

Hi,

I am using excel reader to read the sheets but it does not provide a wildcard function.

For example, i want to put wildcard"YM" to read the specific sheet because the the year and month will be adjusted monthly.

Please let me know how could i make this happen. Thanks in advance

[mlauber71]

@mmngeoh you could use the Read Excel Sheet Names – KNIME Community Hub and then filter the sheet you want with a Rule Engine from the list of sheets for example.

import multiple Excel files - forum question 27716 – mlauber71

This workflow demonstrates how to use the new Excel Reader and path variables...

Reading Multiple Excel files with different sheet names – mlauber71

Excel Reader - force sheet_selection "NAME" with Flow variable – mlauber71

[mmngeoh]

hi @mlauber71 ,

It helps, thanks XDXD