如何用python在excel中输入日期和日程时间？

pip install openpyxl

import openpyxl
from datetime import datetime

wb = openpyxl.Workbook()
sheet = wb.active

date = datetime(2022, 12, 31)  # 日期对象
time = datetime(1900, 1, 1, 12, 30, 0)  # 时间对象

sheet['A1'] = date
sheet['B1'] = time

wb.save('example.xlsx')

import openpyxl
from datetime import datetime

# 创建Workbook对象和选择工作表
wb = openpyxl.Workbook()
sheet = wb.active

# 创建日期和时间对象
date = datetime(2022, 12, 31)
time = datetime(1900, 1, 1, 12, 30, 0)

# 写入日期和时间到Excel单元格
sheet['A1'] = date
sheet['B1'] = time

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