Auto DropDown selection automation and data extraction to excel

Help
,
1

Hi Team,

Greetings!

I have a page where there are 2 dropdowns cascading in nature. First dropdown has 3 values and on selection of each item, second dropdown loads 100 values. on selection of any value of second dropdown, some information will be extracted from database and displayed in tabular format. There is also a button to export this tabular data to excel sheet.

Now this whole process needs to be automated in such a way that on opening the web page, it needs to start selecting the dropdown values and auto exporting data to excel sheet. This process needs to be repeated for all the cascading values of the dropdown.

Please guide me. Many thanks in advance.

Regards,
YPPS.

2

@mppsailaja,

Have you tried anything ? Are you facing any issue here ?

Use Select Item activity to select item from drop down list.

3

Hi Lakshman,

Greetings!

Thanks for the reply. I am new to UI path and just know data scrapping, Write CSV, Type Into and click event. I tried select item but it is not working. It throws an error that UI path doesn’t support this control. I just need some detailed guidance on this. I even searched for some youtube vidoes but no luck.

Please advice.

Regards,
YPPS.

4

@mppsailaja,

Is it possible to access that site from my side ?