Page 1 of 1

How to select drop down values from a web page based on the input given from excel sheet

Posted: Fri Jan 03, 2020 8:03 am
by MahanCodes
Hi Team.

I have a drop down and it contains 4 values.
My test scenario is to select any of these values and validate.To consider this , i have given values in excel sheet. Now i want to use this value and select drop down accordingly.

How can it be done ?


Thanks ,
MahanTesh

Re: How to select drop down values from a web page based on the input given from excel sheet

Posted: Fri Jan 03, 2020 9:43 am
by odklizec
Hi,

Basically, you just have to combine data driven approach (described here) and key sequence action described here.
Simply create a smart folder with data connector, pointing to the excel files with given values. Then in this smart folder, create a recording, which does the combo box item selection, via key sequence and key shortcut actions (using recording variable connected to smart folder data connector). If you don’t use Chrome, you can use simple mouse clicks instead of key sequence/shortcut actions. But as discussed before, mouse clicks does not work with Chrome-based combo boxes.