python 中对比两个Excel 文件内容

 

import   xlrd

def read_excel(fileName):
    global newset
    newset = set()
    global  listdata
    listdata = []
    bk=xlrd.open_workbook(fileName)
    # shxrange=range(bk.nsheets)
    # print(bk.sheet_names())
    #获取指定sheet名字
    sheetName = bk.sheet_by_name('Sheet1')
    # print(sheetName.name)
    #获取总行数：
    rowNum = sheetName.nrows
    # print(rowNum)
    #获取总列数
    colNum = sheetName.ncols
    #获取文件中内容
    for  i  in  range(0,rowNum):
        global  rowdata
        rowdata =''
        for j  in range(0,colNum):

            # print(sheetName.cell_value(i,j),end='  ')
            data = sheetName.cell_value(i,j)
            # print(data)
            rowdata += data+' '
        # print('\n')
        # print(rowdata)
        newset.add(rowdata)
    # print(newset)
    return newset

set1 = read_excel('deploy_architecture_bak.xls')
set2 = read_excel('old_deploy_architecture_20190516.xls')

print('list1list2 相同：%s'%len(set1.intersection(set2)))
print('不同：%s'%len(set2.difference(set1)))