import requests
from PIL import Image
from io import BytesIO
from openpyxl import Workbook
from openpyxl.drawing.image import Image as xlImage
# 下载图片
url = "https://dalongji.oss-cn-guangzhou.aliyuncs.com/021b9862-0374-4309-a3be-c7eb394f8449.jpg"
response = requests.get(url)
img = Image.open(BytesIO(response.content))
# 创建 Excel 文件
workbook = Workbook()
worksheet = workbook.active
# 将图像文件插入到 Excel 文件中
xl_img = xlImage(img)
worksheet.add_image(xl_img, 'A1')
# 保存 Excel 文件
workbook.save('2.xlsx')
import requests
from openpyxl import Workbook
from openpyxl.drawing.image import Image
# 下载图片并保存到本地
url = 'https://dalongji.oss-cn-guangzhou.aliyuncs.com/021b9862-0374-4309-a3be-c7eb394f8449.jpg'
response = requests.get(url)
with open('image.jpg', 'wb') as f:
f.write(response.content)
# 创建Excel文件并写入图片
book = Workbook()
sheet = book.active
sheet['A1'] = 'Image'
img = Image('image.jpg')
sheet.add_image(img, 'B2')
book.save('example.xlsx')