datetime 和calendar的一个小例子

最近做的一个小例子，生成一年12个月的excel表格

# -*- coding:utf-8 -*-
from xlwt import *
from datetime import datetime
import calendar

def get_week_day(date):
    week_day = {
    0: '星期一',
    1: '星期二',
    2: '星期三',
    3: '星期四',
    4: '星期五',
    5: '星期六',
    6: '星期日',
    }
    day = date.weekday()
    return week_day[day]

file = Workbook(encoding='utf-8')
for i in range(1,13):
    table = file.add_sheet('2019年-%d月' % i)
    table.write(0, 0, '日期')
    table.write(0, 1, '上午')
    table.write(0, 2, '下午')
    table.write(0, 3, '出差')
    _, day_all = calendar.monthrange(2020, i)
    k = 0
    for j in range(1, day_all+1):
        date = datetime.strptime('2020/%d/%d'%(i, j), '%Y/%m/%d')
        week_str = get_week_day(date)
        s = '%02d月%02d号'%(i,j) +' ('+week_str+')'
        table.write(j, 0, s)
file.save('2020-work.xls')

简单的表格生成