How to change values of a datatable

Hello,

I had an Excel file attached :

and i want to check over the excel sheet if “VALUE” Existe in a column C, compare the lower cell and the upper cell (related to the retrieved cell: here “EE” and “ZZ”) , if they are equal, replace the initial cell (“ABCD”) with the lower cell valueBook1.xlsx (8.1 KB)

1 Like

You could use a filter activity to give you the row index of whatever you’re looking for. It’s one of the output parameters.
Once you have this, you can change the value via an assign:
dtExample.rows(ObtainedIndex).item("ColumnName")= value

2 Likes

Thank you, the “value” should be the lower cell, or the upper cell: how to retreive them