Create excel template timesheet in current month have Thai holidays with python.
pythonorpython3piporpip3
pip install openpyxl
python timesheet.py [month] [year]
Month and year are optional. If not filled in, the system defaults to the current month and year.
python timesheet.py 2 2023
File name : Timesheet_022023.xlsx
| Day | Time In | Time Out | OT Start | OT Finish | Manager Approve | Detail | Remark |
|---|---|---|---|---|---|---|---|
| 01 | 08:30 | 17:30 | |||||
| 02 | 08:30 | 17:30 | |||||
| 03 | 08:30 | 17:30 | |||||
| 04 | วันเสาร์ | ||||||
| 05 | วันอาทิตย์ |