生活在宁静的角落

from openpyxl import load_workbook
import shutil


comparebook = "2.XLSX"
comparebook2 = "Device List 20190603.xlsx"

wb = load_workbook(comparebook)
wa = load_workbook(comparebook2)
sheet_a = wb['Sheet1']
sheet_b = wa['PCs']

dict = {}
dictb = {}
vat_n = 2
while vat_n <= sheet_b.max_row :
    a = sheet_a.cell(row=vat_n, column=7).value
    b = sheet_a.cell(row=vat_n, column=1).value
    try:
        dict[a.rstrip()] = b.rstrip()
    except:
        print("找不到序列号")

    vat_n +=1

nu = 2
while nu <= sheet_a.max_row:
    q = sheet_a.cell(row=nu, column=6).value
    sheet_a.cell(row=nu, column=1).value = dict[q]

    nu +=1


wb.closed()
wc.save("Device List 20190612.xlsx")

print("匹配完成！请打开：2.XLSX")

pyinstaller.exe -F 文件路径/要打包的文件.py