openpyxl 查找功能

from openpyxl import load_workbook

wb = load_workbook('ff1.xlsx')
ws = wb['表格1']
ws1 = wb['Sheet2']


xy = ws.max_row
xy1 = ws1.max_row
for i in range(2,xy+1):
	
	dh = ws['B%s' %i].value
	# print(dh)
	for r in range(2,xy1+1):
		dh1 = ws1['A%s' %r].value
		wh = ws1['B%s' %r].value
		if str(dh) == str(dh1) and wh != '':
			print('第',i,'条，dh是：',dh,'dh1是：',dh1,'wh',wh)
			ws['J%s' %r].value = wh
		else:
			pass
			#print('dh：',dh)
wb.save('1.xlsx')

这个速度太慢

还是用excel的vlookup函数吧，这个速度快