Quote:
when downloading I need to perform some manipulations
You can't!
You need to:
-
download[
^] a file on local computer,
- perform some calculations,
- save file to fixed network address.
See:
import urllib.request
urllib.request.urlretrieve('http://www.yourcompanysite.com/data/Excel1.xlsx', 'Excel1.xlsx')
Another example:
import requests as req
remote_url = 'http://www.yourcomapnysite.com/Excel1.xlsx'
local_file_name = 'Excel1.xlsx'
data = req.get(remote_url)
with open(local_file_name, 'wb')as file:
file.write(data.content)
To be able to read and modify Excel data, you have so many options... You forgot to mention what kind of manipulations you want to make on downloaded files, so i can't help you more.