批量生成条形码并写入到excel文件

import random
from functools import reduce

from apitest.common import readExcel


def get_imei():
    # 由15位数字组成，前6位(TAC)是型号核准号码，代表手机类型。接着2位(FAC)是最后装配号，代表产地。后6位(SNR)是串号，代表生产顺序号。最后1位(SP)是检验码。
    # 1.将偶数位数字分别乘以2，分别计算个位数和十位数之和;2.将奇数位数字相加，再加上上一步算得的值;3.如果得出的数个位是0则校验位为0，否则为10减去个位数
    t = str(random.uniform(0, 1))[2:16]
    odd_num = t[::2]  # 奇数
    even_num = t[1::2]  # 偶数
    num15 = str((10 - reduce(lambda x, y: x + y,
                             [c // 10 for c in [2 * int(a) for a in even_num]] + [d % 10 for d in
                                                                                  [2 * int(a) for a in
                                                                                   even_num]] + [int(b) for b in
                                                                                                 odd_num]) % 10) % 10)
    imei = t + num15
    # print("imei:%s" %imei)
    return imei

if __name__=="__main__":
    savepath = "imei.xls"
    imeis=[]
    for i in range(1,10,1):
        imei = get_imei()
        imeis.append(imei)
        # print(imeis)
    readExcel.write_new_excel(0,1,imeis,filename=savepath)