import openpyxl
from datetime import date, timedelta
# 创建一个新的工作簿
workbook = openpyxl.Workbook()
# 选择默认的工作表
sheet = workbook.active
# 设置表头
headers = ['日期', '时间段', '预约人']
for col_num, header in enumerate(headers, 1):
sheet.cell(row=1, column=col_num).value = header
# 添加数据行
for i in range(5):
row_num = i + 2
date_str = (date.today() + timedelta(days=i)).strftime('%Y-%m-%d')
for j in range(9):
start_time = f'{j*2}:00'
end_time = f'{j*2+2}:00'
sheet.cell(row=row_num, column=1).value = date_str
sheet.cell(row=row_num, column=2).value = f'{start_time}-{end_time}'
sheet.cell(row=row_num, column=3).value = ''
row_num += 1
# 保存工作簿
workbook.save('meeting_room_reservation.xlsx')
11-13
1万+
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
07-22
1564
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)