python利用myqr模块读取excel批量生成二维码

在网上看了很多，都是用myqr生成单个动态带有背景图的二维码，没有批量生成的例子可以参考，所以经过研究做成了以下代码
需求：读取excel，生成二维码，并把二维码按照不同列放入不同文件夹：

# import qrcode
import xlrd
import os
from MyQR import myqr
import tkinter as tk


def getInfo():
    try:
        data = xlrd.open_workbook(r"E:\qr_png\qrs.xlsx")
        sheetname = "Sheet1"
        table = data.sheet_by_name(sheetname)
        data_cols=table.ncols
        print (data_cols)
        for i in range(data_cols):
            col_values = table.col_values(i)
            muti_code(i,col_values)
        return col_values
    except Exception as e:
        print(e)

def muti_code(i,col_values):
    s = 0
    for machCode in col_values:
        if machCode:
            filename = machCode
            # now_save = 'qr_png/jpg_code/{}.jpg'.format(machCode)
            makdirs(i)
            myqr.run(words=filename,version=4,save_name='qr_png/jpg_code/{}/{}.jpg'.format(str(i),machCode))
            # myqr.run(words=filename,version=4,save_name='qr_png/jpg_code/test/{}.jpg'.format(machCode))
            s += 1
            print("执行成功！第%s列,-------第%s条！" %(str(i+1),str(s)))
        else:
            pass
    print ("执行成功！第%s列,共%s条！" %(str(i+1),str(s)))


def makdirs(i):
    if not os.path.isdir('./qr_png/jpg_code/{}'.format(str(i))):  #创建保存路径
        os.mkdir('./qr_png/jpg_code/{}'.format(str(i)))

getInfo()

代码分享啦，给个赞可好(#^.#)