Ui path Excel activities doubt

Help Activities
, ,
1

I having excel sheet values- if excel sheet particular Coulumn - (ID) - cell value is empty means i have to add the I’d value - in that empty cell.

If values is already there means no need to update the column (ID) cell. How to do that any one help pls

2

Hi @BHUVAN

  1. read the excel

  2. loop through each row in the datatable
    2a. Use if condition with condition as row(“ID”).ToString.Trim.Equals(“”)
    if condition is True, then use assign activity row(“ID”) = Value u need to add

  3. after looping, use write range to write the data to excel using write range :slight_smile:

3

Thanks @NIVED_NAMBIAR :dizzy:

4

Kindly mark it as solution if it helps you

@BHUVAN

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.