Downloading excel file from website

(0) Share

Report

Posted on by Predinkpo

I have been trying to automate downloading excel files from a website. Here is an example:

https://wits.worldbank.org/trade/comtrade/en/country/GBR/year/2022/tradeflow/Imports/partner/ALL/pro...

I am looking at particular trade codes (not all of them) to create a data visualisation.

When inspecting the ui elements, where you click to download the excel file (a small icon on the right hand side) it shows as a png.

I initially tried to build the flow as shown in the attached picture but it is not helpful in this situation.

Does anyone know how I might approach this so I can download the excel files without having to it manually? I am using power automate desktop.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Deenuji_Loganathan_ 6,255 Moderator on at

Like (1)

Report
Copy link

Link copied!
@Predinkpo
Please follow the below suggested flow:
Launch Chrome and Navigate to the Website:
Open Google Chrome and navigate to your URL
https://wits.worldbank.org/trade/comtrade/en/country/GBR/year/2022/tradeflow/Imports/partner/ALL/product/540720#.
Use Click link on web page
Locate and click on the 'Download Excel Sheet' image/button on the webpage as like below.

and make sure the below flag is turned on in the chrome browser
After downloading your chrome would ask to save your file
Then using "Populate text filed in window" capture your dialog text box and you keep your filename as per your wish example I mentioned "productcode_12345" and use press button on window action and save your file

Full code
And also you can turn on you recorder and do your activities it will generate the equaling actions.

Code:
@@source: 'Recorder'
WebAutomation.LaunchChrome.AttachToChromeByUrl TabUrl: 'https://wits.worldbank.org/trade/comtrade/en/country/GBR/year/2022/tradeflow/Imports/partner/ALL/product/540720#' AttachTimeout: 10 BrowserInstance=> Browser
@@source: 'Recorder'
WebAutomation.Click.Click BrowserInstance: Browser Control: appmask['Web Page \'h ... ct/540720#\'']['Image \'Download Excel Sheet\''] ClickType: WebAutomation.ClickType.LeftClick MouseClick: True
@@source: 'Recorder'
UIAutomation.PopulateTextField.PopulateTextField TextField: appmask['Pane \'United Kingdom ... - Google Chrome\'']['Edit \'File name:\''] Text: 'ProductCode_12345' Mode: UIAutomation.PopulateTextMode.Replace ClickType: UIAutomation.PopulateMouseClickType.SingleClick
UIAutomation.PressButton Button: appmask['Pane \'United Kingdom ... - Google Chrome\'']['Button \'Save\''] Simulate: False

Thanks,
Deenuji Loganathan
🤖 Automation Evangelist
Deenuji - Follow me on LinkedIn

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟

Was this reply helpful? Yes No
Predinkpo 8 on at

Like (1)

Report
Copy link

Link copied!

Thank you @Deenuji . This worked perfectly.

Was this reply helpful? Yes No