Hi, I am using excel reader to read the sheets but it does not provide a wildcard function. [image] For example, i want to put wildcard"YM" to read the specific sheet because the the year and month will be adjusted monthly. [image] Please let me know how could i make this happen. Thanks in advance :blush:

@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. [image] import multiple Excel files - forum question 27716 – mlauber71 import multiple Excel files - forum question 27716 [image] This workflow demonstrates how to use the new Excel Reader and path variables... This workflow demonstrates how to use the new Excel Reader and path variables and read Excel sheets There seems to be some questions about how to use the new E… [image] Reading Multiple Excel files with different sheet names – mlauber71 This worklow reads in multiple excel files from a folder. It takes the location and the sheet as flow variables, which are used in the Excel Reader modified fr… [image] Excel Reader - force sheet_selection "NAME" with Flow variable – mlauber71 Excel Reader - force sheet_selection "NAME" with Flow variable

Read Specific Excel Sheets - Wildcard

KNIME Analytics Platform

mlauber71 December 10, 2022, 7:38am 2

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

4 Likes

Use read excel sheet names to read a list of 21 files