Dynamic clicking from excel to web

excel
uiautomation
studio

#1

I have some data in excel.

image.

I want to click in web by using excel data.

.

Can anyone please help ASAP.


#2

Ideally need to see what the selectors are on that website. Is it something you can share? Or at least show us the selectors for the what you want to click.


#3

http://opensource.demo.orangehrmlive.com/index.php/auth/login

uname: admin
pwd: admin

Usually we will have data in excel. Based on that data we need to click in the grid.

Like i said I have a name in excel and i need to click on web.
If name changes in excel it should dynamically search for the name and should click it.


#4

Can you please send xaml file


#5

try something like this.

It pulls the name from the excel, and uses the variable as part of the selector to click on the website. I’ve tried it a few times and seems pretty stable.

Main.xaml (11.4 KB)


#6

For more on this topic …


#7

Thank you very much. Working fine