img https://img-mid.csdnimg.cn/release/static/image/mid/ask/921238995926117.png
img https://img-mid.csdnimg.cn/release/static/image/mid/ask/903738995926197.png
python 3.7.4
openpyxl 3.0.7
我试了下能写入,去掉这行代码呢
# 添加照片到excel
from openpyxl import Workbook
from openpyxl.drawing.image import Image
wb = Workbook()
ws = wb.active
ws['A1'] = 'You should see three logos below'
# 创建一个图片
img = Image('images/xrz.jpg')
# 添加图片到工作表并定位到单元格旁边
ws.add_image(img, 'A1')
wb.save('images/logo.xlsx')