import xlrd2
import requests
import time
import threading
def download():
# 打开文件
data = xlrd2.open_workbook(r'D:\python\test\rent_user.xlsx')#文件的路径
table = data.sheets()[0]#索引从0开始 代表sheets1
nrows=table.nrows#行数
roomList = table.col_values(0)
nameList = table.col_values(1)
urlList = table.col_values(2)
# print('{} {} {}'.format(urlList[375], roomList[375], nameList[375]))
# print('每行数据:',row_list)
sum = 0
for i in range(0, nrows):
try:
r = requests.get(urlList[i], stream=True).content
with open(f"./pic//{roomList[i]}_{nameList[i]}({sum}).jpg", 'wb')as f:# 将内容写入图片
# time.sleep(1)
f.write(r)
print(roomList[i], nameList[i], urlList[i])
sum = sum + 1
print(f"第{sum}张,over")
except:
with open("text.txt", mode='w',encoding='UTF-8')as f:
f.write(str(f"{roomList[i]},{nameList[i]},{urlList[i]} \n"))
f.close()
continue
if __name__=='__main__':
download()
python 读excl的url,并下载到文件夹
最新推荐文章于 2024-04-23 10:24:19 发布