秦小小樱

导航

python 对比 excle 内容一样不一样

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')

 

posted on 2024-12-31 15:11  RonnieQin  阅读(11)  评论(0)    收藏  举报