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

+2 votes
Aug 11 in RPA by anonymous
307 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 Aug 19 by Abha
• 24,320 points

Related Questions In RPA

+3 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
• 13,400 points
4,843 views
0 votes
0 answers

HOW to extract a column data and save it in the new sheet using UIPATH

Sep 12 in RPA by anonymous
• 120 points
77 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
3,376 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,900 points
1,609 views
0 votes
2 answers

Blue Prism- How to retrieve data from webpage

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

answered Sep 13 in RPA by siva cynixit
1,613 views
0 votes
1 answer
0 votes
1 answer

How to extract table and text from pdf file and load into Excel by using workbench commands in automation anywhere

Hey Dhruv, to extract table and text ...READ MORE

answered 6 days ago in RPA by Abha
• 24,320 points
18 views
0 votes
1 answer

How to connect to a database from UiPath and read data from it?

Hi Pratibha, to connect to a database ...READ MORE

answered 7 hours ago in RPA by Abha
• 24,320 points
5 views