openpyxl insert picture problem

[cools0607]

I want to insert a picture into the Excel cell.
The image size needs to fit the cell (even the merged cell) border automatically.
I can find an example to insert a picture in Excel.
But I failed to get the proper image size from the cell border.

[buran]

failed to get the proper image size from the cell border.

What exactly does it mean to get image size from cell border?

Also, please include your code (minimal reproducible example)

[cools0607]

failed to get the proper image size from the cell border.

What exactly does it mean to get image size from cell border?

Also, please include your code (minimal reproducible example)

I attached my code below

import openpyxl
from openpyxl.drawing.image import Image

fn = "SS1.xlsx"
wb = openpyxl.load_workbook(fn)
ws = wb['AA']

cell='B2'     #insert img to B2 cell

# get cell size
width =  ws.column_dimensions['2'].width
height = ws.row_dimensions[2].height


img = Image("my_img.jpg")     # build img
img.width = width          # chamge img width same as cell's width
img.height = height         # chamge img height same as cell's height
ws.add_image(img,cell)      # insert img to B2

wb.save('out.xlsx')             #save file

add attchements (py code/ image/ excel)