"Multiple tabs in excel files"

Papad

Hi, how can I work with an excel file with multiple tabs without changing tab every time I want to make a change?
When I have different excel files I can use loop file operator, but the problem is when I have one excel with many tabs.
Thanks in advance.

yyhuang

Hi @Papad,

if you would like to read the excel sheets one by one, you can iterate the sheet number in “Read Excel”. You can use a list of sheet name to apply a loop or use sheet number as iteration count.



Enjoy!
YY

Papad

Thanks a lot!