Excel column data extraction

Help Activities
, ,
1

I have an Excel file with the input of Name and URL, and as per the input from the USER we need to get the output
Capture
Suppose if the input is One name and we need to get the data from the corresponding Column as output. Can someone help

2

Hi @Varunkumar_Saikumar
welcome to forum

For your case you can try Lookup DataTable activity

If your input is Name, by using Lookup DataTable activity u can get the corresponding data to the name row.

Try out that

Regards,
Nived N
Happy Automation

3

Hi @Varunkumar_Saikumar ,

There are many ways to do this one is already mentioned by @NIVED_NAMBIAR .

You can also try

1 - create dictionary and store it’s value in key value pair and then get any value by passing key value.
Or
2 You can use filter data table activity to filter particular row.
Once you have filtered row just get the value as dt.row(0)(1).tostring

1 Like