如何使用python快速从物料库中匹配出BOM里元器件的料号

import xlwt
import xlrd
import xlutils.copy
#wb=xlwt.Workbook(encoding = 'utf-8')
#ws = wb.add_sheet('My Worksheet')
#ws.write(1,0,label ='456')
#ws.write(1,1,label ='123')
#wb.save('Excel_test.xls')
wb1=xlrd.open_workbook('物料库20200831.xls')
wb2=xlrd.open_workbook('bom V01贴片BOM20200828.xlsx')
wp=xlutils.copy.copy(wb2)
ws3=wp.get_sheet(0)
ws1=wb1.sheets()[0]
ws2=wb2.sheets()[0]
nrow1=ws1.nrows
nrow2=ws2.nrows
print (nrow1)
print (nrow2)
for i in range(3,nrow2-1):
   if  ws2.cell(i, 3).value!='':
       #print(ws2.cell(i,3).value)
       for j in range(1,nrow1-1):
           #if ws1.cell(j,4).value!='' and ws1.cell(j,4).value==ws2.cell(i,3).value:
           if ws1.cell(j, 4).value == ws2.cell(i, 3).value:
               ws3.write(i, 1,ws1.cell(j,0).value)
               ws3.write(i, 2, ws1.cell(j, 1).value)
wp.save('bom V01贴片BOM20200903.xls')