excel填充二维码

from openpyxl import Workbook
from openpyxl.utils import get_column_letter
from openpyxl.styles import PatternFill,Color
from PIL import Image

workbook = Workbook()
worksheet = workbook.active
im = Image.open('C:\\Users\\13375\\Desktop\\python\\xiaohuangya.jpg')
im_width = im.size[0]
im_height = im.size[1]
pix = im.load()
for row in range(1,im_height):
    for col in range(1,im_width):
        cell = worksheet.cell(column=col,row=row)
        pixpoint = pix[col -1 ,row - 1]
        pixcolor = 'FF%02X%02X%02X' % (pixpoint[0],pixpoint[1],pixpoint[2])
        fill = PatternFill(patternType='solid',fgColor=Color(rgb=pixcolor))
        cell.fill = fill
    worksheet.row_dimensions[row].height = 6
for col in range(1,im_width):
    worksheet.column_dimensions[get_column_letter(col)].width = 1
# workbook.save('C:\\Users\\13375\\Desktop\\python\\excel_tiancongerweima.xls')# 文件保存到指定目录下
workbook.save('C:\\Users\\13375\\Desktop\\python\\tiancongerweima.xls')