注:此资料亲身使用,真实可靠,如果运行方面有问题,可以私聊
资源代码都是近一年亲身运行过的,欢迎交流
python 实现自动化办公 人工统计考勤与电脑匹配
源代码如下:
from openpyxl import load_workbook
wb = load_workbook('10月考勤统计.xlsx')
ws = wb.active
dict = {}
for i in ws.iter_rows(min_row=2,values_only=True):
name = i[1]
number = i[-1]
dict[name] = number
wb1 = load_workbook('迟到次数月度统计(10月更新).xlsx')
ws1 = wb1.active
dict1 = {}
for i in ws1.iter_rows(min_row=3,values_only=True):
name1 = i[1]
number1 = i[-1]
dict1[name] = number
if number1 != dict[name1]:
print('员工{}迟到情况不匹配,请核查后更新'.format(name1))