Write specific cell

Help
1

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.

image
image1208×696 78.3 KB

2

@Renan_Pereira

  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.

2 Likes
3

Where do I enter this information?

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

4

@Renan_Pereira

It should be like this.

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