How to download an excel file from a website and to upload it in other one using uipath

Help Activities
, , ,
1

I have to create one uipath code to download one excel file from a website and to upload it in another application using uipath.
So the flow with be something like : login to website, click dropdown button , select the excel option, click download button , store to a folder, upload to other website.
I haven’t create before something similar , and i will need your help for any idea.

This action with run daily .
Do you have any idea please or similar project file ?

2

@uiNew

For

login to website - Use Open Browser Activity
Dropdown button click - Use click activity
selecting the excel option - use click activity
Click download - use click activity
If you get a dialog box then use TypeInto activity to write the path of the folder

Upload steps is as per your process

Try with the above steps and share the issues to forums if you struck

Hope this helps you

Thanks

3

Hello UiNew,
In this video, download and upload files via an HTTP request.

Thanks,
Cristian Negulescu

1 Like
4

Dear Cristian
Invoke Code
Dim httpRequest As HttpWebRequest = DirectCast(WebRequest.Create(“https://www.uipath.com/hubfs/resources/images/products/UiPath-Orchestrator_One_Pager.pdf”), HttpWebRequest)
httpRequest.Method = WebRequestMethods.Http.Get
Dim httpResponse As HttpWebResponse = DirectCast(httpRequest.GetResponse(), HttpWebResponse)
Dim httpResponseStream As Stream = httpResponse.GetResponseStream()
Dim doc As Byte()
Dim ms As MemoryStream = New MemoryStream()
httpResponseStream.CopyTo(ms)
doc = ms.ToArray()
File.WriteAllBytes(“C:\rpa\FORDOWNLOAD\rezuip.pdf”, doc)

Exception thrown by the target of an invocation
Please assist and very much appreciated. Thank you