Get cell value without using For each row activity

datatable
excel

#1

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


How to get specific cell value from excel with value form another cell
#2

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

Regards,
Andrzej


#4

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.