Read excel and get value by name

Help
1

Hello,

I’ve just started to work with excel file reading. So i have a question. I want to get the “Value” by “Name” from Excel. The name is in variable and it’s dynamically changed. So i need to find the name and get the value by name.

There is how it’s look in my example:

Capture
Capture908×536 26 KB

Any ideas how to do that?

2

@sjankus Uipath must accept the name for that particular value must be displayed? Am i correct or any other output ur accepting.

3

Hello Manjuts90,

Thank you for the quick reply. I need to get only “Value”.
For example if i am searching John then my result must be only “15.30”. All the names are unique.

4

test.xaml (6.4 KB)
You can try this, should work the way you’ve described. You can use LINQ to filter values like this.

5

Hello, @KatKon!

Working fine! It’s exactly what i need.

Thank you!

6

@sjankus Try below workflow.
del-------------.xaml (12.6 KB)

input excel:
sh2.xlsx (8.3 KB)