Repeat reading the first sheet in the Read Excel Sheet Names Loop

[xeniaay]

I’m using KNIME version 4.3 and found that even though I followed everything in the Example 05_Read_all_sheets_from_an_XLS_file_in_a_loop, the workflow just produced result of reading the first sheet multiple times (say, I have 3 sheets in the xls file, then it reads 3 times of the 1st sheet). The only difference that I have with the KNIME Example is that I’m connecting an Excel file on a local drive; not url as in the example. I believe the only Flow Variable is set with the Excel Reader node. And I’ve already put “sheet” at the “sheet_name” on the Flow Variables tab. Can anyone tell me what’s wrong please?

Thanks!
Xenia

[SimonS]

Hi @xeniaay,

do you have the sheet selection set to “Select sheet with name”?

Best,
Simon

[xeniaay]

Hi SimonS

No… Thanks for pointing it out. It seems like working after I chose the 2nd one instead of using the default at the first sheet with data.

Thank you so much!

Xenia