name: excel-exporter
description: >
  MANDATORY: Use this skill for ANY Excel spreadsheet export or generation task.
  Triggers: "导出Excel", "下载Excel", "保存为Excel", "生成表格", "export excel", "save as xlsx", "转成Excel", "Excel报告", "生成xlsx".
  CRITICAL: NEVER write ad-hoc openpyxl/xlsxwriter code directly in task scripts. ALWAYS call export_excel.py via this skill.
  Supports: multi-sheet, charts, cell formatting, Chinese content.
  Do NOT use for: reading Excel files for data analysis (use direct openpyxl/xlrd read).
version: "1.0"

# Excel 导出技能

将结构化数据导出为 Microsoft Excel (.xlsx) 格式文件，支持多工作表、表头样式、数据格式化及中文内容。

## CRITICAL RULES

- MUST call `export_excel.py` for ALL Excel export requests; NEVER write ad-hoc openpyxl code
- MUST ensure `sys.path` includes `/workspace/.local/lib/python3.11/site-packages` before importing openpyxl
- Output Excel file MUST be saved to `/workspace/Document/PersonalDocuments/` (personal knowledge base)
- ALWAYS confirm the output path returned by the script; NEVER fabricate a file path
- Data MUST be passed as JSON format via `--data` parameter

## 触发范围

激活场景（MUST activate）：
- 用户说"导出Excel"、"下载Excel"、"保存为表格"、"生成xlsx"
- 用户要求将数据、报表输出为 Excel 格式

## 使用方法

调用 `/workspace/skills/excel-exporter/scripts/export_excel.py`，传入数据参数：

```bash
python3 /workspace/skills/excel-exporter/scripts/export_excel.py \
  --title "表格标题" \
  --data '[{"姓名":"张三","年龄":25},{"姓名":"李四","年龄":30}]' \
  --output "/workspace/Document/PersonalDocuments/output.xlsx"
```

## 依赖说明

| 依赖包 | 版本 | 用途 |
|--------|------|------|
| openpyxl | 3.1.5 | Excel .xlsx 读写核心库 |
| et-xmlfile | 2.0.0 | openpyxl 底层 XML 支持 |
| xlrd | 2.0.2 | 读取旧版 .xls 文件 |
| xlsxwriter | 3.2.9 | 高级 Excel 写入（图表支持） |

依赖安装路径：`/workspace/.local/lib/python3.11/site-packages/`