from openpyxl import load_workbook

START_TIME = '08:00:00'
END_TIME = '17:00:00'
# 加載execel
wb = load_workbook('../data/考勤計(jì)算.xlsx')
ws = wb.active
# 讀取對應(yīng)的行和列
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
    # 比較上班時(shí)間
    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}')

    # 比較下班時(shí)間
    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自增，獲取對應(yīng)的行數(shù)
    i += 1

# 保存excel
wb.save('考勤統(tǒng)計(jì).xlsx')

說明:本文章為大熊自動化辦公課程的學(xué)習(xí)筆記