In Studio how should one traverse multiple sheets

[Prinal_C (Prinal)]

Hi,
This is a Studio question.
In Excel, there are 5 sheets. I want to read Item Code column data from each sheet of Excel. How should I do it in Studio using For Loop only once to reach the Item Code column data ?
Thank you !

[Divyanshu_Divyanshu]

Use Excel Scope activity and get sheets after that you can pass the variable
If you any sample excel i can share the code

[prasath17 (Guru)]

@Prinal_C - Please try like this…In the Excel app scope , as shown below create(ctrl+k) a workbook variable say wb. And then For Each loop (String Type) values as wb.getsheets

[Prinal_C (Prinal)]

@prasath17 I’ll work on this and let you know. Thank you !