wps-schedule

日程/时间表生成器

快速生成格式化的课程表、周计划、活动日程。

When to Use

• 制作课程表
• 周/月工作计划表
• 会议/活动日程安排
• 用户说"做个课程表""周计划表"

When NOT to Use

• 排班值班 → 使用 wps-cn-calendar
• 项目甘特图 → 使用 wps-gantt

模板类型

[1] 课程表 → 周一~周五 × 时间段
[2] 周计划 → 周一~周日 × 时间
[3] 会议日程 → 时间 × 议程
[4] 活动安排 → 多日活动详细时间表

工作流程

Step 1: 确认日程信息

• 类型（课程表/周计划/会议日程）
• 时间范围和时间段划分
• 内容项

Step 2: 生成时间表

from openpyxl import Workbook
from openpyxl.styles import Font, Alignment, PatternFill, Border, Side
import os

def create_timetable(schedule_type, data, output_path=None):
    """生成时间表"""
    wb = Workbook()
    ws = wb.active

    header_fill = PatternFill('solid', fgColor='2C3E50')
    header_font = Font(name='微软雅黑', size=11, bold=True, color='FFFFFF')
    body_font = Font(name='微软雅黑', size=10)
    thin = Side(style='thin')
    border = Border(left=thin, right=thin, top=thin, bottom=thin)

    # 分类颜色
    colors = {
        '语文': 'FADBD8', '数学': 'AED6F1', '英语': 'A9DFBF',
        '物理': 'F9E79F', '化学': 'D7BDE2', '体育': 'ABEBC6',
        '会议': 'AED6F1', '工作': 'A9DFBF', '学习': 'F9E79F',
    }

    if schedule_type == '课程表':
        ws.title = "课程表"
        days = ['时间', '周一', '周二', '周三', '周四', '周五']
        time_slots = data.get('time_slots', [
            '08:00-08:45', '08:55-09:40', '10:00-10:45', '10:55-11:40',
            '14:00-14:45', '14:55-15:40', '16:00-16:45',
        ])

        # 标题
        ws.merge_cells(start_row=1, start_column=1,
                       end_row=1, end_column=len(days))
        ws['A1'] = data.get('title', '课程表')
        ws['A1'].font = Font(name='微软雅黑', size=18, bold=True)
        ws['A1'].alignment = Alignment(horizontal='center')

        # 表头
        for col, day in enumerate(days, 1):
            cell = ws.cell(row=2, column=col, value=day)
            cell.font = header_font
            cell.fill = header_fill
            cell.alignment = Alignment(horizontal='center')
            cell.border = border

        ws.column_dimensions['A'].width = 15
        for col in range(2, len(days) + 1):
            ws.column_dimensions[chr(64 + col)].width = 14

        # 时间段和课程
        courses = data.get('courses', {})
        for row, time_slot in enumerate(time_slots, 3):
            ws.cell(row=row, column=1, value=time_slot).font = body_font
            ws.cell(row=row, column=1).alignment = Alignment(horizontal='center')
            ws.cell(row=row, column=1).border = border
            ws.row_dimensions[row].height = 35

            for col in range(2, len(days) + 1):
                cell = ws.cell(row=row, column=col)
                key = f'{days[col-1]}_{row-3}'
                course = courses.get(key, '')
                cell.value = course
                cell.font = body_font
                cell.alignment = Alignment(horizontal='center',
                                           vertical='center')
                cell.border = border
                # 颜色
                for subject, color in colors.items():
                    if subject in str(course):
                        cell.fill = PatternFill('solid', fgColor=color)
                        break

            # 午休分隔
            if row == 6:
                r = row + 1
                ws.merge_cells(start_row=r, start_column=1,
                               end_row=r, end_column=len(days))
                ws.cell(row=r, column=1, value='午  休').font = Font(
                    name='微软雅黑', size=12, bold=True, color='888888')
                ws.cell(row=r, column=1).alignment = Alignment(
                    horizontal='center')

    if not output_path:
        output_path = f'{schedule_type}.xlsx'
    wb.save(output_path)
    return os.path.abspath(output_path)