Save excel file that is in for of hyperlink

Hi,

How to save a hyperlink in a form of excel. I just want to download and save all the excel file present in hyperlink one by one.
image

1 Like

Hi

We will use here UiPath Web Activity " HTTP Request " in order to directly download file from URL.

fileURLEndPoint – the URL of the file, needs to be download from URL

uipath-download-file-from-url-assign-file-url-endpoint
Assign - fileURLEndPoint

filePath – the file path, where we would save the downloaded file.

uipath-download-file-from-url-assign-filepath
Assign - filePath

Configure the “HTTP Request” activity:

Now configure the " HTTP Request " activity on providing required values into activity properties named “EndPoint” and “ResourcePath” as shown below:

uipath-http-request-download-file-assign-http-request-activity-property-endpoint
Assign - HTTP Request Property - EndPoint

uipath-http-request-download-file-assign-http-request-activity-property-resourcepath
Assign - HTTP Request Property - ResourcePath

Now we just need to execute our workflow and see the magic.

cheers @Riya_Sharma

Hi @Palaniyappan ,

Thanks for quick reply.
Not sure why blank excel is downloading.
could you please help me here?

Thanks,

Check whether it is the same when doing manually

@Riya_Sharma

@Palaniyappan No, it’s contain some data.
Also it required id and password to download a file.