Python 对A表和B表比对两组数据

from openpyxl import workbook
from openpyxl.reader.excel import load_workbook
from openpyxl.styles import PatternFill
import time


# 匹配村
def data_compare(excelfile,find_cun_col,find_country_col,befind_cun_col,befind_country_col,befind_code_col,result_cun_col,result_country_col,result_code_col,result_state_col):
    try:
        excel = load_workbook(excelfile,read_only=False)
        sheet1 = excel["Sheet1"]
        sheet2 = excel["Sheet2"]
        rowmax1 = sheet1.max_row#
        rowmax2 = sheet2.max_row#
        fill = PatternFill(start_color='FFFF00',
                   end_color='FFFF00',
                   fill_type='solid')
        for item in range(2,rowmax1+1): #
            cun_old = sheet1.cell(row=item,column=find_cun_col).value # 获取村数据
            cun_old_pre_two_char = cun_old[:2]
            print("正在比对sheet1的第"+str(item)+"行")
            # find_result = []
            item2