Get cell value without using For each row activity

I have an excel with 2 columns(ID, Account Number). For the ID(given from input dialog box), I need Account number as Output. Without Using For each row activity, Dictionaries, Lists.
Please use Lambda expressions or LinQ.

Thanks,
Vikas Reddy

Have you tried DataTable.Select(string filter)?
It looks to be a pretty straightforward use case.

Regards,
Andrzej

3 Likes

Hi @andrzej.kniola ,

I have a similar requirement,I have 2 columns id and name in excel.I am retrieving ID value in a variable from webpage.Now my requirement is to use the same ID value and do lookup in the excel and get the corresponding name out of the excel.

Can someone help me with the code or sample xaml.