Python 读取Excel中的图片并且保存到本地

import base64
import os
import zipfile

import matplotlib.pyplot as plt
from openpyxl import load_workbook

"""
下载Excel中的图片保存到本地
"""


def download_excel_image_save_local():
    wb = load_workbook('Image.xlsx')
    ws = wb.active
    print(ws)
    output_dir = 'output_image'
    if not os.path.exists(output_dir):
        os.makedirs(output_dir)

    with zipfile.ZipFile('Image.xlsx', 'r') as zip_ref:
        for zip_info in zip_ref.infolist():
            if zip_info.filename.endswith(('.png', '.jpg', '.jpeg', '.gif', '.bmp')):
                img_path = os.path.join(output_dir, os.path.basename(zip_info.filename))
                with zip_ref.open(zip_info) as img_file, open(img_path, 'wb') as out_file:
                    out_file.write(img_file.read())


# 图片转Base64
def image_to_base64(file_path):
    with open(file_path, "rb") as image_file:
        str_encoded = base64.b64encode(image_file.read())
    return str_encoded.decode("utf-8")


# 读取文件夹里的图片
def read_image(folder_path):
    for filename in os.listdir(folder_path):
        print(filename)
        if filename.endswith(('.png', '.jpg', '.jpeg', '.gif', '.bmp')):
            img_path = os.path.join(folder_path, filename)
            image = plt.imread(img_path)
            img_base = image_to_base64(img_path)
            print(img_base)


if __name__ == '__main__':
    download_excel_image_save_local()
    read_image("output_image")

执行结果：