【便签纸】记录一下对比excel列表的小工具代码

本文链接：https://blog.csdn.net/qq_40237865/article/details/109573110

记录一下对比excel列表的小工具代码，方便下次取用，环境python2。

#!/usr/bin/env python
# -*- coding: UTF-8 -*-

import sys
import openpyxl

"""
    对比excel列表，将差异输出
"""

reload(sys)
sys.setdefaultencoding('utf8')

def readxls():
    bk = openpyxl.load_workbook('./excel2.xlsx')#长
    sheet = bk.active
    minrow = sheet.min_row  # 最小行
    maxrow = sheet.max_row  # 最大行
    mincol = sheet.min_column  # 最小列
    maxcol = sheet.max_column  # 最大列

    bk1 = openpyxl.load_workbook('./excel1.xlsx')#短
    sheet1 = bk1.active
    minrow1 = sheet1.min_row  # 最小行
    maxrow1 = sheet1.max_row  # 最大行
    mincol1 = sheet1.min_column  # 最小列
    maxcol1 = sheet1.max_column  # 最大列
    # 按行读取
    atmp=0
    anum=0
    for i in range(minrow, maxrow + 1):
        for j in range(mincol, maxcol + 1):
            cell = sheet.cell(i, j).value
            #print("@"+cell)
            atmp = 0
            for k in range(minrow1, maxrow1 + 1):
                for l in range(mincol1, maxcol1 + 1):
                    cell1 = sheet1.cell(k, l).value
                    if(cell1 in cell):
                        atmp=1
                        anum = anum+1
            if atmp==0:
                print(cell)
    print anum
    pass

def main():
    # 1. 数据读取
    readxls()

# Exec Entry
if __name__ == '__main__':
    main()
    print "success！"