Write cell...no error but not happen

Read Range from Google sheets, For each row in dt
If String.IsNullOrEmpty(row(5).ToString)
Then check row(1) is duplicated or not
If row(1) is not duplicated
Then Assign Status = row(5).ToString
For each item in Status
Write Cell CellAddress: Status

No error in output, but nothing happened in empty cell, can anyone give me a direction?


As you are telling Status is String Data Type but your are passing as I/P Parameter to Cell Address which is of Index Data Type. So there is nothing will happen in your output.
Best Regards,
Likith Rajesh.

1 Like

If this becomes TRUE it means we don’t have any value in the row(5) and it goes to THEN part
That’s why we don’t get value
Make all those assigning and writeline activity in Else Part so that it will assign the value to Status variable

Cheers @MubieSam_Lin

1 Like

Sorry, I did not express clear enough.
There are 3 steps inside For each row in dt

  1. Check Column “Status” at row(5)
    If String.IsNullOrEmpty(row(5).ToString) is TRUE
  2. Check Column “username” at row(1) whether it is duplicated or not
    Assign ListDup = dt.AsEnumerable().Select(function(x) x.Field(of String)(“Site Address”)).GroupBy(function(x) x).Where(function(g) g.Count() > 1).ToList().Count
    If ListDup = 0 is TRUE (not duplicated)
  3. Want to Write Cell to make Column “Status” for this row to be “Not NullOrEmpty”, means job done.

Yes, @likith_rajesh now I know the mistake, but how can i assign a variable = the CellAddress. There are many index or cell in Browse for types, which variable type should I choose?

@Palaniyappan If String.IsNullOrEmpty(row(5).ToString) is False, means job is done, will do nothing in Else. Am I right in this design logic?