Downloading Excel File from a URL

[fitzgerald2022]

I receive and email from our training software that includes a URL Excel file link for the excel data.

Example: www.compliancewire.com/CustomerData/Temp/sample.xlsx (The data is confidential so I couldn't use a real url)

I am trying to use the download tool to download this file and then use a dynamic input tool to use the data.

When I configure the Download Tool to Output to a File it works and I can open the file with excel. When I attempt to use the dynamic input tool (or a regular input tool) I get the following error:

Error: Input Data (5): Target Excel file may be corrupt! Cannot find required file, or element within file: xl/styles.xml

Also when I try to choose a Table Name the there are none I can click

What I have tried

• Changing the .xlsx file format to xls, xlsm, etc

[Shalz]

I am trying to download from Sharepoint.

Can you suggest a solution please

[Raj_007]

Hi, i have tried this to get the .xlsx but i get the error unable to archive for unzipping error

[KelleyS]

The temp.zip worked for a flow I'm working on to download a .xlsm file.  Thank you so much @jamielaird & @fitzgerald2022 !!