import openpyxl import requests wb = openpyxl.load_workbook(('C:\\Users\李西彤\Desktop\HS.xlsx')) sheet = wb['截图收集'] for i in range(59): name = sheet['A' + str(i + 2)].value src = sheet['B' + str(i + 2)].value image = open(name + '.jpg', 'wb') res = requests.get(src) for chunk in res.iter_content(100000): image.write(chunk) image.close()
我也忘了当时看的那位up主的了 ,看到了致歉哈