openpyxl模块应用

将基础信息中的数据读取出填入到业务系统中

from openpyxl import load_workbook
wb1 = load_workbook('基础信息.xlsx')        #打开excel
sheet1 = wb1.get_sheet_by_name('设备')      #读取excel工作簿
wb2 = load_workbook('业务系统.xlsx')
sheet2 = wb2.get_sheet_by_name('系统')

for i2 in range(2,sheet2.max_row+1):      
    l1 = []
    value2 = sheet2.cell(row=i2, column=2).value
    for i1 in range(2, sheet1.max_row + 1):
        if sheet1.cell(row=i1,column=2).value == '服务器':
            value1 = sheet1.cell(row=i1,column=7).value
        else:
            continue
        if value1 == value2:
            sheet2.cell(row=i2,column=10).value = sheet1.cell(row=i1,column=33).value
            l1.append(sheet1.cell(row=i1,column=6).value)
        else:
            continue
    l4 = []
    for i3 in l1:            # 去除重复数据
        if i3 not in l4:
            l4.append(i3)
    l2 = [str(i+',') for i in l4]
    l3 = ''.join(l2)
    sheet2.cell(row=i2,column=12).value = l3

wb2.save('业务系统.xlsx')      #保存修改excel