# coding=gbk
import qrcode
import pandas as pd
m_df = pd.read_excel(r"C:\Users\Administrator\Desktop\红包二维码.xls")
bhs = list(m_df['编号'])
urls = list(m_df['二维码'])
for k, v in enumerate(urls):
qr = qrcode.QRCode(
version=1,
error_correction=qrcode.constants.ERROR_CORRECT_L,
box_size=1,
border=3
)
img = qr.add_data(v)
img = qr.make_image()
with open('img/编号'+str(bhs[k])+'.png', 'wb') as f:
img.save(f)
print()