from openpyxl.styles import PatternFill
from openpyxl.styles import colors
from openpyxl.styles import Font
import openpyxl as pxl
# 加载data1.xlsx文件
workbook_1 = pxl.load_workbook('D:\pythonexercise\pythonProject\excle\月度出库-YTD(人维度)-1735627713577.xlsx')
# 加载data2.xlsx文件
workbook_2 = pxl.load_workbook('D:\pythonexercise\pythonProject\excle\月度出库-YTD(人维度)-1735627191567.xlsx')
# 选择Sheet1对象
workbook_1_sheet_1 = workbook_1['Sheet1']
# 选择Sheet2对象
workbook_2_sheet_1 = workbook_2['Sheet1']
# 进行行、列运算
max_row = workbook_1_sheet_1.max_row if workbook_1_sheet_1.max_row > workbook_2_sheet_1.max_row else workbook_2_sheet_1.max_row
max_column = workbook_1_sheet_1.max_column if workbook_1_sheet_1.max_column > workbook_2_sheet_1.max_column else workbook_2_sheet_1.max_column
for i in range(31, (max_row + 1)):
for j in range(1, (max_column + 1)):
cell_1 = workbook_1_sheet_1.cell(i, j)
cell_2 = workbook_2_sheet_1.cell(i, j)
if cell_1.value != cell_2.value:
cell_1.fill = PatternFill("solid", fgColor='FFFF00')
cell_1.font = Font(color=colors.BLACK, bold=True)
cell_2.fill = PatternFill("solid", fgColor='FFFF00')
cell_2.font = Font(color=colors.BLACK, bold=True)
# 标注完成的文件保存为data3.xlsx文件
workbook_1.save('D\pythonexercise\pythonProject\excle\data1.xlsx')
# 标注完成的文件保存为data4.xlsx文件
workbook_2.save('D:\pythonexercise\pythonProject\excle\data2.xlsx')