python自动化

前期准备

我在python.org下载最新的 python3，win版。
win+r 调出运行，cmd
找到python的文件目录，Scripts

详细代码

import   xlrd
def read_excel(fileName1,fileName2):
    global newset
    newset = set()
    bk1=xlrd.open_workbook(fileName1)
    bk2=xlrd.open_workbook(fileName2)
    shxrange1=range(bk1.nsheets)
    shxrange2=range(bk2.nsheets)
    #print(shxrange)
    if(shxrange1==shxrange2):
        for ii in shxrange1:
                #print(bk.sheet_names())
                #获取指定sheet名字
            sheetName1 = bk1.sheet_by_index(ii)
            sheetName2 = bk2.sheet_by_index(ii)
            # print(sheetName.name)
            #获取总行数：
            rowNum1 = sheetName1.nrows
            rowNum2 = sheetName2.nrows
            # print(rowNum)
            #获取总列数
            colNum1 = sheetName1.ncols
            colNum2 = sheetName2.ncols
            #获取文件中内容
            for  i  in  range(0,rowNum1):
                for j  in range(0,colNum1):

                    # print(sheetName.cell_value(i,j),end='  ')
                    if str(sheetName2.cell_value(i,j)) != str(sheetName1.cell_value(i,j)):
                        print("差异部分：",i,j,"【",sheetName2.cell_value(i,j),sheetName1.cell_value(i,j),"】")
                   
                # print(rowdata)
                #newset.add(rowdata)
    print(newset)
    return newset
set1 = read_excel('1.xls','2.xls')