How to Update specific cell in a column dynamically

Help Studio
, , , , , , ,
2

Hi @anmita

Perform following steps

  1. Use excel scope to open the files
  2. Use for each row in excel to loop through rows
  3. Inside for each use a if condition to check the conditions Eg:

Currentrow("Username").ToString.Contains("Anita")

  1. In then use a assign activity to set the data
    currentrow("Dec") = "90.8" or 90.8

If data is in datatable do the same with for each row in datatable and no excel is needed

cheers