Write specific cell

I need to type “OK” in the cell but I can’t specify the line because it is not fixed. The parameter would be the first null cell of column E and do this on all rows of that column within the for each row activity.


  1. First use Read Range activity to read the data from Excel file and will give you output as DataTable and say ‘inputDT’.

         ForEach row in inputDT
             If String.IsNullOrEmpty(row("OBSERVACAO").Tostring)
            Then row("OBSERVACAO") = "OK")
             Else Nothing

Finally use Write Range activity and pass inputDT to write into Excel file.


Where do I enter this information?

" ForEach row in inputDT
If String.IsNullOrEmpty(row(“OBSERVACAO”).Tostring)
Then row(“OBSERVACAO”) = “OK”)
Else Nothing"


It should be like this.

  • ForEach Row activity
    • IF activity
      - Assign activity
      Leave it as blank and no need to use any activity here.