1 Excel生成二维码
1.0 模糊二维码
(1)下载ExcelAPI更新工具:http://www.excelapi.net/Download/ExcelAPIUpdateTool.zip
(2)工具安装及使用教程:http://www.excelapi.net/zh-CN/Home/Help
(3)Excel新建链接:如A1中:https://blog.csdn.net/Xin_101
(4)新的格栅中使用:=QRCode(A1,width)
(5)生成二维码
1.2 高清二维码
(1) Excel菜单栏空白出右键,选择自定义功能区
(2)在主选项卡中勾选:开发工具
(3)表格中(如A1)中输入链接:https://blog.csdn.net/Xin_101
(4)标题栏选择开发工具,点击插入,选择后一个其他控件
(5)其他控件中选择:Microsoft BarCode Controller 16.0
(6)表格空白区域拖动鼠标,生成条形码
(7)右键生成的条形码,选择Microsoft BarCode Control属性
(8)样式中选择:11 -- QR Code,生成二维码
(9)右键二维码,选择:属性,找到名称LinkCell其值设定为链接所在的单元格,如A1
(10)生成二维码.
2 代码生成二维码
import qrcode
import numpy as np
import matplotlib.pyplot as plt
import matplotlib.image as mpimg
from qrcode import QRCode
'''
Instantiation QRCode class.:params version: an integer value from 1 to 40 that controls the size of QRCode.
:params error_correction: L About 7% or less errors can be corrected, M(default) 15%, H 25%.
:params box_size: control how many pixels each "box" of the QRCode is.
:params border: control how many boxes thick the border should be(default 4).
'''
qr = QRCode(version=1, error_correction=qrcode.constants.ERROR_CORRECT_L,box_size=10,border=4,)
'''Code infomation.'''
data = "https://blog.csdn.net/Xin_101"
'''Add information to Code.'''
qr.add_data(data=data)
'''Enable cololr setting.'''
qr.make(fit=True)
'''Generate image.'''
image = qr.make_image(fill_color="black", back_color="yellow")
image.save("./images/qrcode.png")
image_show = mpimg.imread("./images/qrcode.png")
'''Undisplay axis.'''
plt.axis("off")
plt.imshow(image_show)
3 二维码信息识别
import zxing
'''Instantiation BarCodeReader class.'''
readapi = zxing.BarCodeReader()
code_info = readapi.decode("./images/qrcode.png")
print("QRCode inofs: {}".format(code_info))
print("QRCode info: {}".format(code_info.parsed))
- Result
QRCode inofs: BarCode('https://blog.csdn.net/Xin_101', 'https://blog.csdn.net/Xin_101', 'QR_CODE', 'URI', [(75.0, 255.0), (75.0, 75.0), (255.0, 75.0), (225.0, 225.0)])
QRCode info: https://blog.csdn.net/Xin_101
[参考文献]
[1]http://www.excelapi.net/zh-CN/Home/Help
[2]https://pypi.org/project/qrcode/5.1/
[3]https://github.com/dlenski/python-zxing/blob/master/zxing/init.py
[4]https://www.cnblogs.com/lsdb/p/9728621.html
