安装相关依赖包,
pip install openpyxl openpyxl_image_loader
代码如下,
from openpyxl import load_workbook
from openpyxl_image_loader import SheetImageLoader
xlsx_path = "your_excel.xlsx"
saveDir = "save_imgs_path"
wb = load_workbook(xlsx_path)
ws = wb[wb.sheetnames[0]]
image_loader = SheetImageLoader(ws)
num = ws.max_row
## 假设第一行为列名, 从第二行开始寻找
for i in range(2, num + 1):
try:
row_number = i
## 遍历A列寻找图片, 若你需要在C列寻找,则改为C
column = "A"
images = image_loader.get(column + str(i))
if isinstance(images, list):
for j, image in enumerate(images, start=1):
image_name = "image_{}_{}_{}.jpg".format(row_number, column, j)
image.save(saveDir + image_name)
else:
image_name = "image_{}_{}.jpg".format(row_number, column)
images.save(saveDir + image_name)
except ValueError:
print("第{}行没有图片".format(i))