秦小小樱

导航

< 2025年3月 >
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5

统计

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   RonnieQin  阅读(3)  评论(0编辑  收藏  举报

相关博文:
阅读排行:
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
点击右上角即可分享
微信分享提示