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 !
Use Excel Scope activity and get sheets after that you can pass the variable
If you any sample excel i can share the code
@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
@prasath17 I’ll work on this and let you know. Thank you !