How to know a compare the value of a row's first cell in excel in uipath

Help
, ,
1

Hi, I have an excel sheet with 2 columns with headers of “key”, “value”. I want to check for each condition that a certain value exists in “key” of a row, then assign a variable to the “value” of that row.

for example, if a cell value “from” exists in the “key” of a row, I must assign a variable to the corresponding “value” cell. please help me out.

2

can you please explain bit more clear @Srikavya_n

3

@Srikavya_n

  1. Use Read Range activity to read the data from excel file and will give you output as DataTable and say ‘DT’. And then use ForEach Row activity to iterate that DataTable.

    ForEach row in DT
    IF row(“Key”).Tostring.Length > 0
    Then row(“Value”) = “value”
    Else Nothing

Finally use Write Range activity to write into Excel file.

4

Screenshot%20(7)
Screenshot%20(7)1920×1080 130 KB

5

i want to check if a row’s first key under header - key value.
for example

dataRow[Key].toString == “from” , then assifn variable to its corresponding cell in value i.e., “sdjsco.com” into a variable

6

Screenshot%20(8)
Screenshot%20(8)1920×1080 153 KB

7

getting confused at specifying the condition at if condition

8

@Srikavya_n

In IF condition, specify single = instead of double equal.

9

use single = for checking the condition.