判断两个Excel表内容是否存在不同数据 【记录】

def contrast_excel():
    l_p = []  # 小表
    
    wb_pri = xlrd.open_workbook('/Users/bunsuketake/Desktop/台账.xls')  # 打开原始文件

    sheet1 = wb_pri.sheet_by_name("Sheet1")

    nrows = sheet1.nrows
    wb_tar = xlrd.open_workbook('/Users/bunsuketake/Desktop/台账的副本.xls')  # 打开目标文件

    sheet2 = wb_tar.sheet_by_name("Sheet1")
    nrows2 = sheet2.nrows

    for i in range(1, nrows):
        test01 = sheet1.row_values(i)
        for j in range(1, nrows2):
            test02 = sheet2.row_values(j)
            l_p.append(test02)
            if test01 not in l_p:
                return False
            else:
                return True

def contrast_excel():
    l_p = []  # 小表
    l_t = []  # 大表
    l_n = []  # 新表

    wb_pri = xlrd.open_workbook('/Users/bunsuketake/Desktop/台账.xls')  # 打开原始文件

    sheet1 = wb_pri.sheet_by_name("Sheet1")

    print(sheet1)

    nrows = sheet1.nrows  # 获取所有行

    for i in range(1, nrows):
        value = sheet1.row_values(i)

        l_p.append(value)

    wb_tar = xlrd.open_workbook('/Users/bunsuketake/Desktop/台账的副本.xls')  # 打开目标文件

    sheet2 = wb_tar.sheet_by_name("Sheet1")
    nrows2 = sheet2.nrows

    for j in range(1, nrows2):
        number = sheet2.row_values(j)

        l_t.append(number)

    for i in l_p:

        if i not in l_t:
            l_n.append(i)

    return l_n