python3 判断.xlsl表的两列是否一致

数据

代码

# -*- coding: utf-8 -*- """ Created on Fri Nov 1 15:29:41 2019 @author: Bai Depei """ import openpyxl as ox #判断两个签字表中的两列数据是否一致，相等 #-----------------------------读取两个表---------------------------------- wb_1 = ox.load_workbook('Earth system science签到表.xlsx') sheet_names_1 = wb_1.sheetnames sheet1 = wb_1['11.04'] rows=sheet1.max_row columns=sheet1.max_column name_1 = [] for cell in list(sheet1.columns)[2]: a = cell.value name_1.append(a) wb_2 = ox.load_workbook('Earth System Science-签字版-ok.xlsx') sheet_names_2 = wb_2.sheetnames sheet2 = wb_2['Worksheet'] rows_2=sheet2.max_row columns_2=sheet2.max_column name_2 = [] for cell in list(sheet2.columns)[3]: b = cell.value name_2.append(b) #----------------------------判断两个表中的名字是否一一对应---------------------- for i in range(len(name_1)): if name_1[i] == name_2[i]: print(str(name_1[i])+'='+str(name_2[i])) print(' yes ') else: print(name_1[i],name_2[i]) print(' no ')

结果

------------------------------------------------ 版权归作者 小白是哪个小白_ 所有，转载、引用请注明链接出处。