wps-gantt

name	wps-gantt
description	项目甘特图。输入任务名称、开始结束日期，自动在Excel里画出甘特图， 用颜色显示进度，不用买Project也能做漂亮的项目排期表。 用于帮助用户制作项目甘特图。当用户提到甘特图、项目排期、时间线时触发。 Gantt chart generator in Excel - no Project software needed.
license	MIT
user-invocable	true
argument-hint	[项目任务列表/需求]
allowed-tools	Read, Grep, Glob, Bash, Write, Edit
metadata	{"author":"BWKYD","title":"甘特图生成","description_zh":"根据任务列表在Excel中生成甘特图，用于项目进度管理","tags":["甘特图","项目管理","排期","Excel","WPS"],"version":"1.0.1","license":"MIT"}

甘特图生成器

任务列表 → Excel甘特图。不用Project也能做项目排期。

When to Use

• 制作项目计划/排期表
• 需要可视化的时间线
• 项目进度跟踪
• 用户说"做个甘特图""项目排期表"

When NOT to Use

• 复杂项目管理 → 建议使用专业工具
• 普通表格 → 使用 wps-docx-writer

工作流程

Step 1: 确认任务信息

每个任务需要：

• 任务名称
• 开始日期
• 结束日期（或工期天数）
• 负责人（可选）
• 进度百分比（可选）

Step 2: 生成甘特图

from openpyxl import Workbook
from openpyxl.styles import (Font, Alignment, PatternFill,
                              Border, Side, numbers)
from openpyxl.utils import get_column_letter
from datetime import datetime, timedelta
import os

def create_gantt(tasks, output_path=None):
    """
    tasks = [
        {'name': '需求分析', 'start': '2026-04-01', 'end': '2026-04-07',
         'owner': '张三', 'progress': 100},
        {'name': '系统设计', 'start': '2026-04-08', 'end': '2026-04-14',
         'owner': '李四', 'progress': 60},
        ...
    ]
    """
    wb = Workbook()
    ws = wb.active
    ws.title = "项目甘特图"

    # 计算日期范围
    all_dates = []
    for t in tasks:
        all_dates.append(datetime.strptime(t['start'], '%Y-%m-%d'))
        all_dates.append(datetime.strptime(t['end'], '%Y-%m-%d'))
    min_date = min(all_dates)
    max_date = max(all_dates)
    total_days = (max_date - min_date).days + 1

    # 样式
    header_fill = PatternFill('solid', fgColor='2C3E50')
    header_font = Font(name='微软雅黑', size=10, bold=True, color='FFFFFF')
    bar_fill = PatternFill('solid', fgColor='3498DB')
    done_fill = PatternFill('solid', fgColor='2ECC71')
    milestone_fill = PatternFill('solid', fgColor='E74C3C')
    today_fill = PatternFill('solid', fgColor='F39C12')
    thin = Side(style=, color=)
    border = Border(left=thin, right=thin, top=thin, bottom=thin)

    
    left_headers = [, , , , , ]
     col, h  (left_headers, ):
        cell = ws.cell(row=, column=col, value=h)
        cell.font = header_font
        cell.fill = header_fill
        cell.alignment = Alignment(horizontal=)

    
    ws.column_dimensions[].width = 
    ws.column_dimensions[].width = 
    ws.column_dimensions[].width = 
    ws.column_dimensions[].width = 
    ws.column_dimensions[].width = 
    ws.column_dimensions[].width = 

    
    date_start_col = (left_headers) + 
    use_weekly = total_days > 

     use_weekly:
        
        week_start = min_date - timedelta(days=min_date.weekday())
        col = date_start_col
         week_start <= max_date:
            cell = ws.cell(row=, column=col,
                          value=week_start.strftime())
            cell.font = Font(name=, size=, color=)
            cell.fill = header_fill
            cell.alignment = Alignment(horizontal=)
            ws.column_dimensions[get_column_letter(col)].width = 
            week_start += timedelta(days=)
            col += 
    :
         d  (total_days):
            date = min_date + timedelta(days=d)
            col = date_start_col + d
            cell = ws.cell(row=, column=col, value=date.strftime())
            cell.font = Font(name=, size=, color=)
            cell.fill = header_fill
            cell.alignment = Alignment(horizontal=, text_rotation=)
            ws.column_dimensions[get_column_letter(col)].width = 

    
    body_font = Font(name=, size=)
     row_idx, task  (tasks, ):
        ws.cell(row=row_idx, column=, value=row_idx-).font = body_font
        ws.cell(row=row_idx, column=, value=task[]).font = body_font
        ws.cell(row=row_idx, column=,
                value=task.get(, )).font = body_font
        ws.cell(row=row_idx, column=, value=task[]).font = body_font
        ws.cell(row=row_idx, column=, value=task[]).font = body_font
        progress = task.get(, )
        ws.cell(row=row_idx, column=,
                value=).font = body_font

        
        start = datetime.strptime(task[], )
        end = datetime.strptime(task[], )

         use_weekly:
            week_start = min_date - timedelta(days=min_date.weekday())
            s_col = date_start_col + (start - week_start).days // 
            e_col = date_start_col + (end - week_start).days // 
        :
            s_col = date_start_col + (start - min_date).days
            e_col = date_start_col + (end - min_date).days

         c  (s_col, e_col + ):
            cell = ws.cell(row=row_idx, column=c)
             progress == :
                cell.fill = done_fill
            :
                cell.fill = bar_fill
            cell.border = border

    ws.row_dimensions[].height = 
    ws.freeze_panes =   

      output_path:
        output_path = 
    wb.save(output_path)
     os.path.abspath(output_path)

Step 3: 交付

1. 生成甘特图Excel文件
2. 冻结窗格方便查看
3. 颜色说明（蓝=进行中，绿=已完成，红=里程碑）

示例

# 生成甘特图
/wps-gantt 帮我做个项目甘特图，需求分析2周→设计1周→开发4周→测试2周→上线

# 从数据生成
/wps-gantt 用tasks.xlsx里的任务列表生成甘特图

# 更新进度
/wps-gantt 更新项目甘特图的进度