# -*- coding: utf-8 -*-
# @Time   : 2022-11-20
# @Author : Carl_DJ

"""
實現(xiàn)功能：
    1、對比兩個excel表中的內(nèi)容，
    2、對差異的結(jié)果寫入新的excel表中

"""

from openpyxl.styles import PatternFill
from openpyxl.styles import colors,Font
import openpyxl as vb

#讀取 需要對比的excel表
workbook_a = vb.load_workbook(r'表1.xlsx')
workbook_b = vb.load_workbook(r'表2.xlsx')
#讀取需要對比的sheet名
sheet_a = workbook_a['Sheet1']
sheet_b = workbook_b['Sheet1']
#遍歷所有的行與列
maxrow = sheet_a.max_row
maxcolumn = sheet_b.max_column

#循環(huán)對比表格的所有單元格數(shù)據(jù)
for i in range(1,maxrow):
    for j in range(1,maxcolumn):
        cell_a = sheet_a.cell(i,j)
        cell_b = sheet_b.cell(i,j)
        #如果有差異數(shù)據(jù)，就標識出來(藍色加粗字體，黃色填充)，
        if cell_a.value != cell_b.value:
            cell_a.fill = PatternFill("solid",fgColor='FFFF00')
            cell_a.font = Font(color=colors.BLUE,bold=True)
            cell_b.fill = PatternFill("solid",fgColor='FFFF00')
            cell_b.font = Font(color=colors.BLUE,bold=True)
#差異結(jié)果存入新的excel表中
workbook_a.save('表1_差異結(jié)果.xlsx')
workbook_b.save('表2_差異結(jié)果.xlsx')

print("執(zhí)行對比完成")