Hi. I seem to have an issue with the Excel Reader. I have multiple sheets in an Excel Workbook, which I am passing through in a loop as a flow variable. When I happen to set the sheet name flow variable, the Excel Reader only reads the first sheet name. I also tried to use the index value as well, in which I generated index values before passing them through a loop, and still, the Excel Reader only reads the first sheet, regardless of what flow variables you set for it. Any workaround for this?

Hello @denzilsdn , try option “Select sheet with name” :wink: [image] Excel Reader ignores flow variable for sheet!? KNIME Analytics Platform Hello, for a productive workflow I tried to replace deprecated nodes and ran into errors. I made some tests and found out that the reason seems to be the Excel Reader in combination with flow variables. I created a sample workflow based on one of the examples to discuss and clarify here: [image] 05_Read_all_sheets_from_an_XLS_file_in_a_loop.knwf (30.3 KB) I was unable to integrate my source excel file into workflow, therefore I upload it separately: Mappe2.xlsx (10.2 KB) In the results y… Br, Ivan

Issue with Excel Reader (Reading sheets as flow variable)

KNIME Analytics Platform

ipazin April 6, 2022, 6:57am 2

Hello @denzilsdn,

try option “Select sheet with name”

Br,
Ivan

3 Likes