For each loop (what to enter for [in])

Help Studio
1

I have used excel application scope to and read range excel to read the sheets that I want such as like “Sheet1”, “Sheet2”

image
image664×637 12.6 KB

However, I’m not very sure on how to use the for each loop, what do I enter inside the blank box [in] (enter a VB expression)

2

image

3

Hi @PHS_BE

If you need to loop through all the values in excel?

If yes, Use For each row in data table activity

image
image828×445 24.3 KB

Regards
Gokul

4

HI,

If you need to iterate each sheet in your workbook, the following will help you.

image
image1241×836 33.1 KB

Please note that TypeArgument of ForEach is String.

Regards,

5

Thank you so much :slight_smile:

1 Like
6

Thank you so much :slight_smile: :laughing:

1 Like
7

Hi @PHS_BE

Kindly close this topic by mark as solved. It will help for others too.

Regards
Gokul