How to extract data from website and save it to excel using Blue Prism?

+2 votes
Aug 11 in RPA by anonymous
87 views

1 answer to this question.

0 votes

Hey, you can use following steps to extract data from a website and save it to excel using Blue Prism:

  1. Create a new Object from Studio tab using Create Object. Give Object name and description and click Finish.
  2. Now, double click on the newly created Object and it will open the Object Studio
  3. Then click on Application Modeller and and keep the Application Name unchanged. Click Next and select Browser-Based Application and again click Next.
  4. Select 'A browser that is launched from an executable file' and click Next. Now provide the browser exe file path and go Next.
  5. Enter the URL you wish to open and go Next. Now leave the default options as it is and keep on clicking Next. Finally, click Finish.
  6. Now you have your Application modeller which can be launched now to open the desired web url.
  7. Next, click on Element 1 (default element created in modeller) and then click Identify. 
  8. Select the desired web element or datatable from which you want to extract data. This will populate all the attributes of the web element in the Element 1 Attributes section. Click Apply.
  9. Now, in the Object Studio, add a Navigate activity and add your Object and select an action for it (like Launch).
  10. Next, add a Read activity and set it's Element Data to GetTable. Now store this table into a datatable type variable.
  11. Now you can use this datatable variable to write the data to excel file.
answered 3 days ago by Abha
• 19,780 points

Related Questions In RPA

+2 votes
1 answer

How to extract data from a website and save it to excel using UiPath?

Hi Piyush, if you want to extract ...READ MORE

answered Mar 8 in RPA by Anvi
• 11,890 points
2,673 views
0 votes
4 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

These are the steps to add two ...READ MORE

answered Aug 2 in RPA by Shivi Singhal
2,621 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 56,520 points
1,359 views
0 votes
1 answer

Blue Prism- How to retrieve data from webpage

The ideal way to accomplish this would ...READ MORE

answered Oct 17, 2018 in RPA by Priyaj
• 56,520 points
1,238 views
0 votes
1 answer
0 votes
1 answer

How to delete some specific sheets from an existing excel file using vb.net code?

You can create a output of Excel ...READ MORE

answered Jul 27, 2018 in RPA by Atul
• 5,530 points
424 views
0 votes
1 answer

how get the specific data from an excel and write in another excel file in uipath?

@Renuka, I agree with your approach. You ...READ MORE

answered 3 days ago in RPA by Abha
• 19,780 points
55 views
0 votes
1 answer

How to extract numbers from a web page using Uipath ?

Hi, you can simply use GetText and Message ...READ MORE

answered 3 days ago in RPA by Abha
• 19,780 points
17 views