Search and excel

Learn Academy Courses
1

Hello;

I need your help on an important matter.
As in the attached example;
The robot will search the ebay site. It will transfer the name and price of the first result on the page to Excel, then move on to the next search and transfer the name and price of that result to Excel as well. This will continue like this. It will then combine the results into a single Excel. How do I do this?
Thanks.

2

Hi @m.a.akay ,
Thanks for reaching out to UiPath community.
You can try these simple steps.
-Use the Open Browser activity to navigate to eBay.

-Use the Type Into activity to enter the search query into the eBay search bar and press Enter.

-Use the Data Scraping wizard to scrape the name and price of the first result. Configure the wizard to select the relevant data on the webpage.

-Use the Write Range activity to write the scraped data to an Excel sheet. Make sure to configure the Excel file and sheet appropriately.

-Use a for each activity to repeat the above steps for each subsequent search.

Regards,
@pratik.maskar

3

@m.a.akay

Instead everytime writing to excel …use a loop and then inside that use search and get the data and use merge datatable to merge all the results into single table

Then use one write range to write the data

Cheers

4

Hey @m.a.akay

You can follow these steps:

Step 1 :

  • Use the “Open Browser” activity to open the eBay website.
  • Define variables to store the search queries and the Excel file path.
  • Add a counter variable to keep track of the search iterations.

Step 2 :

  • Use a loop activity such as “While” or “Do While” to iterate through the search queries.
  • Inside the loop, use the “Type Into” activity to enter the search query in the eBay search field.
  • Use the “Click” activity to initiate the search.
  • Use the “Data Scraping” wizard to extract the name and price of the first result.
  • Store the extracted data in variables.

Step 3 :

  • Use the “Excel Application Scope” activity to open the Excel file.
  • Use the “Write Cell” activity to write the extracted name and price data to the Excel file.
  • Increment the row index to move to the next row in the Excel file.
  • Close the Excel application scope.

Step 4 :

  • Increase the counter variable to move to the next search query.
  • Check the loop condition to determine if all search queries have been processed.

Step 5 :

  • Save the automation workflow.
  • Run the workflow to perform the search and extraction process for each search query.
  • Also verify that the extracted data is correctly written to the Excel file.

HAPPY AUTOMATION!!

5

So can you prepare a sample and send it to me?
It may be easier to understand with an example

Tank you

6

So can you prepare a sample and send it to me?
It may be easier to understand with an example

Tank you

7

Problem solved. Thanks for support.