Extract specific data from a list of hyperlinks in Excel

Hi guys,

I have a list of hyperlinks (same website) on column A in Excel.

I need to extract specific information from these links (e.g. Product Code, Name, Description, Price) to the corresponding Excel columns.

I’ve watched a million tutorials, however I am unable to find certain UiPath functions in my StudioX version - pls help with a solution :pray:

Any reply would be greatly appreciated :slight_smile:

Hi

Just some clarification required like
for each url do you want to open in browser , fetch that particular data ( Product Code , Name Description,Price) and place the information in same row next url column

Confirm if this is what you are expecting

Hi Lakshmi,

Thanks so much for responding. That’s right, it’s exactly what I’m looking for. :pray:

one way is

use excel process scope > use excel file
add required columns if required or if already present ignore
for each excel row
Use Browser/ Application scope
use go to url give input from currentitem(“FieldName”)
do activities as you required and same time you can provide the values to respective fields by like “CurrentRow.ByField(“Des”).StringValue”
use navigate Browser activity (select from dropdown option you required either close tab or goto home)





image
Hope this helps

Hi everyone,

I am experiencing the same issue. !
I am not sure how to extract the hyperlinks and obtain the text content from the link. Moreover
need instructions.