python高版本精确控制excel图片位置

python高版本精确控制excel图片位置

from openpyxl import Workbook
from openpyxl.drawing.image import Image
from openpyxl.drawing.spreadsheet_drawing import AbsoluteAnchor
from openpyxl.drawing.xdr import XDRPoint2D, XDRPositiveSize2D
from openpyxl.utils.units import pixels_to_EMU, cm_to_EMU
import qrcode



def createQRCode(x,y):
    qr = qrcode.QRCode(version=1, box_size=3, border=0.5)
    qr.add_data('https://example.com')
    qr.make(fit=True)
    img = qr.make_image(fill_color='black', back_color='white')
    img.save('qrcode.png')

    wb = Workbook()
    ws = wb.active
    img = Image('qrcode.png')
    p2e = pixels_to_EMU
    h, w = img.height, img.width
    positie = XDRPoint2D(p2e(x), p2e(y)) #像素 x ,y
    size = XDRPositiveSize2D(p2e(h), p2e(w))
    img.anchor = AbsoluteAnchor(pos=positie, ext=size)
    ws.add_image(img) 
    wb.save('test.xlsx')

createQRCode(200,10)