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 ')

结果

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