python 生成二维码 插入 excel

生成二维码

def make_qrcode(data: str, path: str):
    qr = qrcode.QRCode(
        version=1,
        error_correction=qrcode.constants.ERROR_CORRECT_L,
        box_size=10,
        border=4
    )
    qr.add_data(data)
    qr.make(fit=True)
    img = qr.make_image(fill_color="black", back_color="white")
    img.save(path)

pandas 读取 excel

  data = pd.read_excel(file_name)
    data.replace(np.nan, None, inplace=True)
    obj_list = data.apply(lambda x: tuple(x), axis=1).values.tolist()

excel 插入本地图片

   workbook = xlsxwriter.Workbook('images_bytesio.xlsx')
    worksheet = workbook.add_worksheet()

    filename = 'logo.png'
    image_file = open(filename, 'rb')
    image_data = BytesIO(image_file.read())
    image_file.close()

    worksheet.insert_image('B8', filename, {'image_data': image_data})

    workbook.close()

excel 插入远程图片

 workbook = xlsxwriter.Workbook('images_bytesio.xlsx')
    worksheet = workbook.add_worksheet()

    url = 'http://admin.msh-dev.sugonup.com//media/default/2023/09/0a/2a463b35_7828_small.jpg'
    image_data = BytesIO(urlopen(url).read())
    worksheet.insert_image('B2', url, {'image_data': image_data})

    workbook.close()