Search String in Excel for Corresponding Values

[anonymous3 (non)]

Hi all, I have extracted a string from a pdf I am working with and I would like to search up its ID and Code in an Excel Spreadsheet. For example, I have extracted “Apple” from my pdf and I have to look up its ID and Code in the image below. How do I do so?

[Eric_Wong_Test (Eric Wong)]

dr = dt.AsEnumerable.SingleOrDefault(Function (x)x(0).ToString = value)
dr is DataRow

[anonymous3 (non)]

Hi @Eric_Wong_Test ,

I got an error saying: Value of type “System.Data.DataRow” cannot be converted to “String”.

I inputted your code in an Assign activity.
My dt variable is “DataTable” Type.

[Eric_Wong_Test (Eric Wong)]

if you want to get the value in datarow
string = dr(0).ToString

[NIVED_NAMBIAR (NIVED N)]

Easiest way is to use the lookup datatable activity

Check this workflow

workflow : Main.xaml (8.9 KB)

sample excel file used: test.xlsx (7.5 KB)

Regards,

Nived N
Happy Automation