python 开始时间至结束时间获取周别码并写入表格中

import datetime
import xlwt

f = xlwt.Workbook(encoding='utf-8')
sheet1 = f.add_sheet('week code', cell_overwrite_ok=True)
startDate = '2021-01-01'
endDate = '2030-12-31'
dt = datetime.datetime.strptime(startDate, "%Y-%m-%d")
date = startDate
weeks = []
years = []
months = []
dates = []
while date <= endDate:
    weeks.append(str(int(dt.strftime('%U')) + 1))
    years.append(dt.strftime('%Y'))
    months.append(dt.strftime('%m'))
    dates.append(date)
    dt = dt + datetime.timedelta(1)
    date = dt.strftime("%Y-%m-%d")
sheet1.write(0, 0, 'time')
sheet1.col(0).width = 3000
sheet1.write(0, 1, 'year')
sheet1.write(0, 2, 'month')
sheet1.write(0, 3, 'week')
sheet1.write(0, 4, 'year_code')
sheet1.write(0, 5, 'month_code')
sheet1.write(0, 6, 'week_code')
for i in range(0, len(weeks)):
    sheet1.write(i+1, 0, dates[i])
    sheet1.write(i+1, 1, years[i])
    sheet1.write(i+1, 2, months[i])
    sheet1.write(i+1, 3, weeks[i])
    sheet1.write(i+1, 4, years[i])
    sheet1.write(i+1, 5, months[i])
    sheet1.write(i+1, 6, weeks[i])
f.save('week_code.xls')