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')
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· 【自荐】一款简洁、开源的在线白板工具 Drawnix