利用openpyxl向excel表格中写进图片，但无法保存Excel表格

Question

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

Answer 1

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')