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

+2 votes
Aug 11, 2019 in RPA by anonymous
6,275 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
• 28,140 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,150 points
21,588 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
2,080 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, 2020 in RPA by Sirajul
• 59,230 points
1,975 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, 2020 in RPA by Karan
• 19,610 points
1,822 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
13,860 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
• 58,090 points
4,050 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
• 28,140 points
4,300 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 17, 2019 in RPA by Abha
• 28,140 points
8,892 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP