import urllib.request #可以打开网站
import json,requests
###########下载文件
url = 'http://www.besttest.cn/data/upload/201710/f_36b1c59ecf3b8ff5b0acaf2ea42bafe0.jpg'
r=requests.get(url)
print(r.status_code)#查看状态码
print(r.content)
f = open('bt.jpg','wb')#w是写字符串,加个b代表写二进制
f.write(r.content)
f.close()
#########下载html
url='http://www.nnzhp.cn/archives/732'
r = requests.get(url)
f=open('nnzhp.html','wb')
f.write(r.content)
f.close()
import xlrd,xlutils,xlwt