from openpyxl import load_workbook

START_TIME = '08:00:00'
END_TIME = '17:00:00'
# 加载execel
wb = load_workbook('../data/考勤计算.xlsx')
ws = wb.active
# 读取对应的行和列
start_row = 2
i = 0
for row in ws.iter_rows(min_row=2,min_col=3,max_col=4):
    check_start = row[0].value
    check_end = row[1].value
    # 比较上班时间
    if check_start is None:
        state = '未打卡'
    elif str(check_start) > START_TIME:
        state = '迟到'
    else:
        state = ''
    ws.cell(row=start_row+i,column=5,value=f'{state}')

    # 比较下班时间
    if check_end is None:
        state = '未打卡'
    elif str(check_end) < END_TIME:
        state = '早退'
    else:
        state = ''
    ws.cell(row=start_row+i,column=6,value=f'{state}')

    # 令i自增，获取对应的行数
    i += 1

# 保存excel
wb.save('考勤统计.xlsx')

说明:本文章为大熊自动化办公课程的学习笔记