Assign dynamic variable to list of name from Excel

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.



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

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