通过URL从excel下载web图像并保存到Python中的文件夹

import pandas as pd
import requests
import os

# 1. 读取Excel文件
df = pd.read_excel('data.xlsx')

# 2. 提取图像URL
image_urls = df['Image URL']

# 3. 下载图像并保存
for url in image_urls:
    response = requests.get(url)
    filename = url.split('/')[-1]  # 获取URL中的文件名
    with open(filename, 'wb') as f:
        f.write(response.content)
        print(f"图像 {filename} 下载成功")

# 4. 移动图像到指定文件夹
target_folder = 'images'
os.makedirs(target_folder, exist_ok=True)
for file in os.listdir():
    if file.endswith('.jpg') or file.endswith('.png'):
        os.rename(file, os.path.join(target_folder, file))