#!/usr/bin/env python3
from openpyxl import load_workbook,Workbook 

wb = load_workbook('courses.xlsx')
ws = wb[wb.sheetnames[0]]
wt = wb[wb.sheetnames[1]]
wc = wb.create_sheet('combine')
wc.append(['\u521b\u5efa\u65f6\u95f4', '\u8bfe\u7a0b\u540d\u79f0', '\u5b66\u4e60\u4eba\u6570', '\u5b66\u4e60\u65f6\u95f4'])

for i in list(ws.values)[1:]:
    for j in wt.values:
        if i[1] == j[1]:
            wc.append(list(i)+[j[-1]])
wb.save('courses.xlsx')

s = set()
l = list(wc.values)[1:]
for i in L:
    s.add(i[1].strftime('%Y'))

for y in s:
    wb = Workbook()
    ws = wb.active
    ws.title = y
    for i in l:
        if i[0].strftime('%Y') == y:
            ws.append(i)
    wb.save('{}.xlsx'.format(y))
copy