How can I repeat the "type into activity" with each time another value to be inserted? without copy/paste the "type into activity"

Help Studio
5

Hello @mce

Read the excel file into a Data Table using the Read Range Activity.
The output of the read range activity is save in a Data Table variable.
Now, you have to iterate through the rows of this Data Table, for this use For Each Row In Data Table Activity.
Inside this activity’s body insert the Type Into activity
The text that you want to type in is written in the cell of the excel file which has been read in a Data Table Variable and is now in iteration loop with one row at a time.
In order to access the row cell you just have to pass the index of the column (in data table index of column starts from 0)
so lets say in a row your data is in 3rd column then type CurrentRow(2).ToString, here CurrentRow is a temp variable that stores the Data Row in iteration. This name can be changed and it appears in For Each Row in Data table Activity. See the attached image below

image

inputDT - Data Variable which stores the excel file data (Same variable used in output property of read range activity)
CurrentRow(2) - Third column value of current row in iteration

Hope it help.
Thank You