python网上批量下载表格_在python中从网上下载一个excel文件

I have the following web address:

dls = "http://www.muellerindustries.com/uploads/pdf/UW SPD0114.xls"

I tried to download the file:

urllib2.urlopen(dls, "test.xls")

This made a file called "test.xls" but this is clearly an html file. If I opened the html file in firefox it opened an excel file, but if I opened the file in excel it was definitely not the excel file I was looking for.

If I have a web address like the one above, how do I make python download the excel file as an excel file?

解决方案

This would save the excel file in the same folder that the script was ran from.

import urllib

dls = "http://www.muellerindustries.com/uploads/pdf/UW SPD0114.xls"

urllib.urlretrieve(dls, "test.xls")