Currently I’m trying to download data from “https://agmarknet.gov.in/PriceTrends/SA_Pri_Month.aspx” this website. Where first I have to select commodity from a drop-down list and then I have to select year from a drop-down list and then I have to select month from a drop-down list then i have to click on submit button and then i have to click on the export to excel button.
So, i want to automate the whole process so that i get data of each commodity for every year and of every month.
so i decided to put the months drop-down list into the Find Children activity and then i applied For Each Loop but i’m facing problem in fetching all the months from the list as the select item activity is selecting the label of the drop-down list.
Please help me in getting all the data for all the commodity for every year and every month.