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

+2 votes
Aug 11, 2019 in RPA by anonymous
2,381 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, 2019 by Abha
• 27,930 points
what if the get table option doesnt appear??
Could you please elaborate on your query?

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, 2019 in RPA by Anvi
• 14,090 points
13,302 views
0 votes
0 answers

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

Sep 12, 2019 in RPA by anonymous
• 120 points
663 views
0 votes
1 answer
0 votes
1 answer

RPA : How to extract specific data from scanned pdf and write into excel in blueprism?

Your query is similar to https://www.edureka.co/community/6509 ...READ MORE

answered Mar 23 in RPA by Sirajul
• 57,890 points
517 views
0 votes
1 answer

how to extract information from a pdf using regex and send that information to an excel spreadsheet?

You can use the following high level activities to ...READ MORE

answered Apr 9 in RPA by Karan
• 16,040 points
205 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, 2019 in RPA by Shivi Singhal
6,422 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
• 57,640 points
2,467 views
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 Oct 10, 2019 in RPA by Abha
• 27,930 points
1,792 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 Oct 16, 2019 in RPA by Abha
• 27,930 points
3,087 views