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.