一个简单的python-execl查重

import xlrd
import xlwt
from xlutils.copy import copy

def setStyle(color):
    style = xlwt.XFStyle()  # 初始化样式
    font = xlwt.Font()
    font.colour_index = color
    style.font = font
    return style
def read_excel_xls(path1,path2):

    workbook1 = xlrd.open_workbook(path1)  # 打开工作簿
    sheets1 = workbook1.sheet_names()  # 获取工作簿中的所有表格
    worksheet1 = workbook1.sheet_by_name(sheets1[0])  # 获取工作簿中所有表格中的的第一个表格
    workbook2 = xlrd.open_workbook(path2)
    sheets2 = workbook2.sheet_names()
    worksheet2 = workbook2.sheet_by_name(sheets2[0])
    new_workbook2 = copy(workbook2)
    w2r = new_workbook2.get_sheet(sheets2[0])
    for i in range(0, worksheet1.nrows):
        for j in range(0, worksheet1.ncols):
            if worksheet1.cell_value(i, j) != worksheet2.cell_value(i, j):
                w2r.write(i, j, "change", setStyle(40))  # 像表格中写入数据（对应的行和列）
    new_workbook2.save(r'C:\Users\mimilam\Desktop\testres.xls')

def main():
    global fpath,fcomppath
    print("输入源文件地址")
    fpath = input()
    print("输入比较文件地址")
    fcomppath = input()
    read_excel_xls(fpath,fcomppath)
if __name__ == '__main__':
    main()