Read Excel Table Cell

Help
1

Team,

Being new to uipath got a basic question. I have a table in excel like below

      A    B

Sun 11 22
Star 33 44
Moon 55 66

I have the input value as Star and B. Based on this i want to extract 44. Kindly provide a sample xaml.

2

Hi
hope these steps would help you resolve this
–use a excel application scope and pass the file path as input
–inside the scope use a READ RANGE activity and get the output with a variable of type datatable named dt
–use a for each row loop and pass the above datatable variable as input
–inside the loop use a IF condition like this
row(0).tostring.equals(“Star”) and row(1).tostring.equals(“33”)
if true it will go to THEN part where we can use a writeline activity and mention like this
row(2).tostring

thats all you are done
kindly try this and let know for any queries or clarification
Cheers @Robotics