read multiple excel files - strange behaviour

[vstefano]

Good morning,
I see a very strange behaviour in looping in sheets from an excel file (see attached). Excel file is very simple, three sheets, one column, 50rows first sheet, 50 the seconds and 25 the third, total 125 rows.
The loop returns 150 rows instead of 125 and in addition it seem repeating just the first sheet.

What I am doing wrong? Is this a bug?

test_fogli.xlsx (11.5 KB)

[ipazin]

Hello there @vstefano,

have you checked Select sheet with name in node configuration? If not than it will read first sheet three times. See here for more and additional explanation:

Help, to read sheets with loop

please help, I try to read the sheets in one excel with the loop, I think everything is setted well but the result is unexpected. and how to upload my workflow for your inspection? the problem is the variable for sheet name didn’t work. [image]

Br,
Ivan

[vstefano]

Thanks Ivan,
you are right. It is a bit misleading tough as I had already inserted sheet name as a variable, and this should work by default.
I confirm that now with your suggestion it is working.
Thanks again,
Stefano

[ipazin]

Hello @vstefano,

I understand. Many users already stumbled across this. However using flow variable for a specific configuration option doesn’t change other configuration option (haven’t seen this behavior in any node). Possible solution would be to expose flow variable configuration of sheet name in main configuration tab. This way before setting flow variable you would need to check Select sheet with name (now called By name) and avoid this issue.

Br,
Ivan