Extract a few sentences from a webpage to an existing excel file

Help Studio
, ,
#1

I extracted a table data and set an auto-save in excel file.

UiPath1
UiPath11220×652 32.6 KB

In the next step, I would like to add 2 new columns in the excel file (indicated in red) and extract 2 types of information from the same website.

UiPath5
UiPath5780×676 25.6 KB

To get those information, I need to click the company name one by one

UiPath2
UiPath21075×494 66.4 KB

And 2 screen captures below are the 2 types of information I would like to add onto the worksheet.

UiPath3
UiPath3927×819 30.7 KB

(Only the first LeadUnderwriter)

UiPath4
UiPath41135×765 85.9 KB

(extract the first 5 sentences)

Could anyone give me advice what activities to use?

#2

get attribute activity would work here perfectly for your case.

#3

I would add to data table before exporting to excel. You can loop the data table and find the right info on the site, add to data table then export.

#4

I will try that, thank you!

#5

I need to get data from each of the external links(company names’ hyperlink).
In that case, can the data I extracted go to the right row? (e.g. Bumble Inc’s Lead Underwriter to be on H2 and Company Description on I2)
Also, the hyperlink name(company name) changes every time I use the RPA. Would the method that you recommended still work?