<p>找到一个使用<a href="https://openpyxl.readthedocs.io/en/latest/tutorial.html" rel="nofollow noreferrer">Openpyxl</a>的解决方案(即可以在不打开excel(excel工作簿)的情况下读取excel文件):</p>
<pre><code>from openpyxl import load_workbook #https://openpyxl.readthedocs.io/en/latest/index.html
import requests
import time
url = 'https://www.oslobors.no/ob/servlets/excel?type=history&columns=TIME%2C+BUYER%2C+SELLER%2C+PRICE%2C+VOLUME%2C+TYPE&format[TIME]=dd.mm.YY%20hh:MM:ss&format[PRICE]=%23%2C%23%230.00%23%23%23&format[VOLUME]=%23%2C%23%230&header[TIME]=Statoil&header[BUYER]=Kj%C3%B8per&header[SELLER]=Selger&header[PRICE]=Pris&header[VOLUME]=Volum&header[TYPE]=Type&view=DELAYED&source=feed.ose.trades.INSTRUMENTS&filter=ITEM_SECTOR%3D%3DsSTL.OSE%26%26DELETED!%3Dn1&stop=now&start=1493935200000&ascending=true'
file_name = 'DownloadFile.xlsx'
while True:
try:
resp = requests.get(url)
with open(file_name, 'wb') as output:
output.write(resp.content)
break
except Exception as e:
print(str(e))
time.sleep(3)
wb = load_workbook(file_name)
ws = wb['data']
for row in ws.rows:
for cell in row:
print(cell.value)
</code></pre>