How to check the input sfring in excel if data exists extract the coumn B data linq query

Help Activities
, ,
1

Hi Team,

I have one excel wifh bulk data. I have input string like A12345 which is available in A6 i need to extract B6 value using linq query
I am just giving example i need to extract the data in dynamic way.

Kindly help
Thanks.

2

Hi @Ramudu

You can refer this thread
https://forum.uipath.com/t/how-to-extract-the-data-in-excel-using-linq-query/727317/16

3

Thanks @rashmisingh2695 for quick response.

When i was tried to use the above lina query i am getting following error.

IMG_20241011_190749
IMG_20241011_1907491920×956 276 KB

And this is my input data

IMG_20241011_191127
IMG_20241011_1911273120×4208 991 KB

33367111 is the output value.

Kindlf help

4

Can you please share the query you are using.

Also, you an try to change the data type in linq according to data type of values in datatable.

5

@Ramudu

You can directly use excel lookup activity

Cheers