Search for a particular variable in Excel and get the value in the other column of the same data row

[ashok.p (Ashok)]

Hi,
I am trying to search for a variable in Excel and if found, need to get the value in the other column corresponding to the same datarow.
For Example, If I have 3 columns A, B ,C in an excel. I have to search for 50 (In column B) and need to fetch the the value in column ‘C’(i.e 25)
can some one please help.

[lakshman (Ganta lakshman)]

@ashok.p

1. Use Read Range activity to read the data from Excel file and will give you output as Datatable and say DT.

2. And then use For Each Row activity to iterate that Datatable DT.

ForEach row in DT
If row(1).ToString = “50”
Then print row(2).ToString
Else skip it.

[ashok.p (Ashok)]

hi,
this works, thanks