Download Image from Link

Help
1

Hi friends,

I have a problem which I do not know how to solve.

I need to download the files that are behind a Link in Excel. See picture below:

image
image1032×225 12.8 KB

As you can see in the Excel there is a Column “Scan …” with the name of the file (picture). The link behind the picture is “https://-----” If I click on this link, the picture is downloaded automatically by my browser.

When I load the Excel in a data table, the only value in the Scan Attribure is the name of the file, which is not usefull for me.

Can somebody tell me an approach how to download these files behind these links?

Many thanks and best regards,
Robert

2

@BOTFORCE Basically you need to get a url from Hyperlink. Please refer

4 Likes
3

Hi @BOTFORCE

The before link for all this images is same ??
For eg :- www.google.com/phnix_form_logo.png
same for www.google.com/image.png

Means the www.google.com is same to all imgs before der images names ??

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

4

Hi Pratik,

no, all links are unique.

Thx. Robert

5

I used the Activity PAckage from BalaReva to get the URL in an easy way. I have to fill in the Excel Application Scope the Cell.

Now, how can I fill this in dynamically (like in a for each loop). In this Excel Applicatoin Scope.
As the Hyperlinks are always in column N, I only need to add the excel rownumber dynamically.

Is this possible in an Excel Application Scope?

6

My goals ist to replace the entry in these cells with their real hyperlinks in the excel.

7

My goals ist to replace the entry in these cells with their real hyperlinks in the excel. I cannot use a data table because as soon as I load the data into the data table, I only find the name of the files to download in the cells and not the hyperlinks to it. So there I start losing information and have to manage it before in Excel.

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.