from openpyxl import load_workbook
from PIL import Image
wb = load_workbook("test.xlsx")
ws = wb[wb.sheetnames[0]]
for image in ws._images:
# 输出图片的位置信息
# 列号
col = image.anchor._from.col
# 行号
row = image.anchor._from.row
print(type(col))
print(row)
img = Image.open(image.ref)
path = "%s-%s.png" % (col, row)
# 保存图片
img.save(path)
wb.close()



