Excel如何将图片链接转换成单元格图片呢？

Question

#Excel 图片链接 批量转单元格图片
#救救孩子吧
Excel如何将图片链接转换成单元格图片呢？我的图片是没有后缀的，请问应该如何操作呢？拜托各位大神。
https://cf.shopee.es/file/876b00c7f945a8eb352a94c957cb42a8

Answer 1

在获取图片保存时，添加后缀名为jpg，然后使用sheet.add_image写入单元格即可，参考如下代码。

from openpyxl.drawing.image import Image
from openpyxl import load_workbook
import pandas as pd
import requests
wb=load_workbook('t1214.xlsx')
ws=wb.active
df=pd.read_excel('t1214.xlsx')
for i,url in enumerate(df['link']):
    res=requests.get(url,headers={'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.93 Safari/537.36 Edg/96.0.1054.53'})
    with open(f'shopee{i}.jpg','wb') as f:
        f.write(res.content)
column_width = 12.25
row_height = 60.10
ws.column_dimensions['D'].width = column_width
for i in range(2,ws.max_row+1):
    ws.row_dimensions[i].height = row_height 
    img=Image(f'shopee{i-2}.jpg')
    img.width, img.height=(60,60)
    ws.add_image(img,f'D{i}')
wb.save('t1214.xlsx')

如对你有帮请点击采纳按钮。