Assign dynamic variable to list of name from Excel

Help
1

Hello All,

I was wondering if anyone could help me with theloop below.

Ok, so I have an Excel file which only has name (for example, cell A1:A10). I would like to generate a loop in which I can assign a variable to the first name (cell A1), perform a certain sequence of actions, then change the variable to the next name on the list (cell A2) and so on…

I understand that I can import the data from the Excel file with the activity “Read Range”, but I dont see how I can assign the name in a loop.

If anyone can help me or point me in the right direction, that would be super appreciated.

Thanks!

Max

2

If you read excel using read range you will be having data table with one column (once you have values in only one column) then take for each row in dt_out inside gmfor each row, take assign key = your variable , value = row.item(0).ToString

1 Like
3

HI,
Refer the following code. You might get some idea sample.xaml (6.6 KB)
Thanks.