|
马上注册,结交更多好友,享用更多功能^_^
您需要 登录 才可以下载或查看,没有账号?立即注册
x
下载图片是空白的,但是我多下载几次显示又正常了
import os
import pandas as pd
import requests
from pathlib import Path
df = pd.read_excel(r'c:\Users\19394\Desktop\最终版.xlsx',sheet_name='表1')
for index,row in df.iterrows():
name = row['名称']
url = row['链接']
print(f'正在下载[{name}]:{url}')
respnose = requests.get(url)
basename,ext = os.path.splitext(url)
if ext not in ['.jpg','.png','.jpeg','.webp']:
ext = '.jpg'
filepath = Path(fr'D:\练习\临时文件\{name}{ext}')
with filepath.open('w+b') as fp:
fp.write(respnose.content) |
|