图片用二进制文件保存
import requests
res = requests.get('https://js-ec.static.yximgs.com/ufile/adsocial/ec8ffd6c-0c4a-4b00-8046-83116a29ff74.jpg')
f=open('mdc360.jpg','ab')
f.write(res.content)
f.close()
import pandas as pd
import requests
data=pd.read_excel(r'D:\Users\Desktop\抓取图片测试.xlsx')
s = data['SKU']
a = data['address']
for i in range(len(s)):
print(s[i])
# res = requests.get(s[i])
# f=open('{a[i]}.jpg','ab')
# f.write(res.content)
# f.close()