注:此资料亲身使用,真实可靠,如果运行方面有问题,可以私聊
资源代码都是近一年亲身运行过的,欢迎交流
python 实现自动化办公 筛选并汇总考勤差异数据
源代码如下:
from openpyxl import load_workbook,Workbook
wb = load_workbook('数据筛选/10月考勤统计.xlsx')
ws = wb.active
# for i in ws['A']:
# print(i.value)
li = []
for i in ws[1]:
li.append(i.value)
nb = Workbook()
ns = nb.active
ns.append(li)
for row in ws.iter_rows(min_row=2,values_only=True):
name = row[1]
time = row[3]
number = row[-1]
if number>=3 and time>=45:
print('{}迟到了,迟到了{}次,{}分钟'.format(name,number,time))
ns.append(row)
nb.save('10月迟到人员信息.xlsx')