Loop all the Excel Sheet and Process

Dear All,

I would like to get your best suggestion on regarding the below process flow.

I have 5 sheets in my workbook. each sheet there is account number.
I have created a bot program to read 1st sheet and process, i need the same bot should ready each sheet through loop and process.

image
image
image

@jaffer_sadiq ,You could use for each excel sheet activity to read each excel sheet in workbook

2 Likes

Hello @jaffer_sadiq

You can use the below acitivty.

For Each Excel Sheet

image

Thanks

2 Likes

@jaffer_sadiq