导出datetime excel python

import openpyxl
from openpyxl.utils import get_column_letter
from openpyxl.styles import Alignment
from datetime import datetime

# 创建一个新的Excel文件
wb = openpyxl.Workbook()
ws = wb.active

# 设置表头
headers = ['日期', '时间']
for col_num, header in enumerate(headers, 1):
    col_letter = get_column_letter(col_num)
    ws.column_dimensions[col_letter].width = 15
    cell = ws.cell(row=1, column=col_num, value=header)
    cell.alignment = Alignment(horizontal='center')

# 添加datetime数据
datetimes = [datetime(2022, 1, 1, 10, 30, 0), datetime(2022, 1, 2, 15, 45, 0)]
for row_num, dt in enumerate(datetimes, 2):
    ws.cell(row=row_num, column=1, value=dt.date())
    ws.cell(row=row_num, column=2, value=dt.time())

# 保存Excel文件
wb.save('datetime_data.xlsx')