from this link also extract petrol and diesel rate
the question sounds like:
- select in dropdown a particular value
- extract resulting table
So in general we can do:
- extract drop down values - using find children activity and post prossing the children
- Select Item Acitvity - drown down value selection
- Data Scraping - Extract Table data into a datatable
- Write range - write extracted datatable to Excel
@ppr I want to extract all states cities petrol and diesel rate and that data write into excel
this is the images of task
given description is doing this
in case of these concepts are new to you then do some training courses from UiPath Academy. Here are the relevant concepts presented and it gives you some starter help
thank you @ppr actually I know how to write that extracted data into notepad I created also but I dont know how to write into excel all like states cities from dropdown
So check UiPath Academy.
Datatable to Excel we do use write range as mentioned above
I will try to help you on your way:
- First you would need to scrape all the states from the dropdown, and then iterate through all of them with a For Each Row
- Use the name of each state (in a variable) in the selector to click in the dropdown
- Scrape the data from the page
- Add the state column
- Merge the state results to the totals
- When the For Each is finished, use Write Range to write the totals to Excel
Fuel prices.zip (1.3 MB)
can u hlp me , kindly, can u share bot.