in this website i have one excel file in that file i have many data like excel cell,excel clone etc so i have to one by one search the data after search after search i get so many result so i have to extract data like name summarry,name ,overview and write in excel file. if i search excel cell so i get so many result in that i have to take alll the data value also there arre many pages so that all page data also i have to take . after all page done then next search for another data that is excel clone or any and also make sheet like excel cell sheet, excel clone sheet. please any one know attach your workflow.
Hey @Mandan_Purnima as per my understanding i think you are trying to read excel file and then from the row you pick each row data and then paste into the website fetch details write into the excel Right .
if yes
1- Excel process scope - use excel file - read range - for each row - outside of the for each use application/browser activity and inside the for each use type into -pass the current row data - and use get text activty to get the search data output -and pass the variable in the write cell activity and enable the auto increament option
or if you want to extract all data from the website use table extraction activity also instead of get text and to write use write range
cheers
Sorry but i haven’t that specific sample.i can only suggest the flow . for better understanding and learning kindly go through some UiPath Learning channels .
Here in 1 st image i search after I get so many results so go to everyone and extract specific data and also in 3 picture there are multiple page so also extract that page data after its done go to next search that is excel color or any if that done also attache your workflow
its cant possible to share the entire flow, but i will give you inputs how you can achieve this process,
1.use the read range to read your input from excel.
2.open you web application
3.use for each row in data table pass your input data table and create one data table with respective columns based on your requirement for output by using build datatable activity
4.inside loop use type into activity to search your excel data in search box.
5.go to end of the page and extract how many pages you have.
6.based on page number use loop
7.inside of that use extract data table and indicate the name of the each item.
8.you will get output as datatable you for each row to navigate the each item
9.take one assign activity and get the name of the item
10.inside loop use click acitivity to click respective item. pass the name variable to click on respective item.
11.from there you can extract data what exactly you want. and add it to your output datatable
12.after completing all items in the page click on next page(out side of current for each row…).
13.use write range to write the data to your excel.
