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

+2 votes
Aug 11, 2019 in RPA by anonymous
1,352 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,800 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,010 points
9,172 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
340 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/65092 ...READ MORE

answered Mar 23 in RPA by Sirajul
• 50,530 points
83 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
4,802 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,530 points
2,116 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, 2019 in RPA by siva cynixit
2,688 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,800 points
1,064 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,800 points
1,192 views