Get text for many links

Help
1

Hello guys.

I just graduated the foundation training and I have a task to automate.

I need you help.

I have around 300 links saved in a Excel workbook, I have to open them, copy the text and paste the information next to the link saved in Excel.

Let me give you an example:

Here are some links:

I need to copy the presented information on site:

image
image1195×542 22.1 KB

And paste the text back in Excel.

I know that I can use the get text. I just want to know how to set the robot to open all the links, get the text and paste it back in Excel. Are there any ways to do it the fast way?

Thank you
Any ideas how can I do it the fast way?

Thank you and best regards,

Vadim

2

@calin
-use excel application scope and read range to read the excel and store it in a variable say dt1
-use for each row inside the do of excel application scope and give the input of for each row
-create a counter variable of type int with 1 as default value.
-give assign activity in for each row and give like this counter=counter+1
-inside the body give open browser activity and give the url as row(0).to string
-and use get text activity and store it in a variable say outtext
-now use write cell activity and and at the range give like this “B”+counter.tostring.
-and give write range activity and give the path of same excel sheet address.

1 Like
3

Thanks for your reply.

What do you mean by saying " and give the input of for each row"?

Thank you,

Vadim

4

@calin once you read the input store it in a variable say dt1 the dt1 is the input for for each row