OpenPyXLを使ってPythonでエクセルファイルに画像を追加する

pip install openpyxl pillow

from openpyxl import Workbook
from openpyxl.drawing.image import Image

def main():
    wb = Workbook()

    ws = wb.active
    ws.title = "てすと"

    add_image(ws, "sample1.png", "A1")
    add_image(ws, "sample2.png", "M1")

    wb.save("test_img.xlsx")

def add_image(ws, img_path, cell):
    img = Image(img_path)
    ws.add_image(img, cell)

if __name__ == "__main__":
    main()