For each row in Column A Insert Some Value

Help Activities
2

Hi

Welcome to uipath forum

Hope the below steps would help resolve this

  1. Use a excel application scope and pass filepath as input and use a read range activity and get the output as dt

  2. Now use a FOR EACH ROW activity and pass dt as input

  3. Inside the loop use a IF activity with a condition like this

NOT String.IsNullOrEmpty(CurrentRow(“ID”).ToString.Trim)

If true it goes to then block where use a assign activity like this

CurrentRow(“Status”) = “100”

Note : if you want append 100 to the existing value in column B then mention like this in assign activity

CurrentRow(“Status”) = “100” + CurrentRow(“Status”).ToString.Trim

This can handle any dynamic number of rows

Cheers @Md_Hidayat

1 Like