Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from openpyxl import load_workbook
- wb = load_workbook("인사기록.xlsx")
- ws = wb.active
- # 엑셀의 B3부터 데이터가 존재함
- # A1 (1, 1) B1 (1, 2) C1 (1, 3)
- # A2 (2, 1) B2 (2, 2) C2 (2, 3)
- # A3 (3, 1) B3 (3, 2) C3 (3, 3)
- for row in range(3, ws.max_row):
- if ws.cell(row, 2).value is None:
- break
- 직급 = ws.cell(row, 2).value
- 소속 = ws.cell(row, 3).value
- 시작 = ws.cell(row, 4).value
- 종료 = ws.cell(row, 5).value
- 근무일 = 종료 - 시작
- print(직급, 소속, 근무일.days)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement