如何在openpyxl中将图像与特定位置和大小对齐

pip install openpyxl
pip install pillow

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

wb = Workbook()
ws = wb.active

img = Image('path_to_image.png')

img.width = 200  # 设置图像的宽度
img.height = 100  # 设置图像的高度

ws.add_image(img, 'B2')  # 将图像添加到B2单元格

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

# 创建工作簿和工作表
wb = Workbook()
ws = wb.active

# 加载图像文件并调整大小
img = Image('path_to_image.png')
img.width = 200
img.height = 100

# 将图像添加到指定单元格
ws.add_image(img, 'B2')

# 保存工作簿
wb.save('output.xlsx')