python 获取excel信息,下载对应图片
import pandas as pd
from openpyxl import load_workbook
import requests
import re
if __name__ == '__main__':
pic_url = []
workbook = load_workbook("videoday.xlsx")
sheet = workbook['JSON 20220627162613']
for row in sheet.iter_rows():
for cell in row:
if cell.coordinate.startswith('B'):
print(cell.value)
pic_url.append(str(cell.value))
break
# 使用get()来获取url
for i in range(len(pic_url)):
url = pic_url[i]
imgres = requests.get(url)
with open("/addr/{}.jpg".format(i+1), "wb") as f:
f.write(imgres.content)
print("下载完毕")