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: single-sheet, multi-sheet, auto column width, auto row height, freeze header, auto filter, Chinese content.
  Do NOT use for: reading Excel files for data analysis (use direct openpyxl/xlrd read).
version: "1.1"

# Excel 导出技能

将结构化数据导出为 Microsoft Excel (.xlsx) 格式文件，支持单/多工作表、自适应列宽行高、表头冻结、自动筛选及中文内容。每个 sheet 末尾自动追加"以上内容由 ECclaw 生成"签名。

## 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` (single sheet) or `--sheets` (multi sheet)

## 触发范围

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

## 使用方法

### 单工作表

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

### 多工作表

```bash
python3 /workspace/skills/excel-exporter/scripts/export_excel.py \
  --sheets '[{"title":"告警记录","data":[{...}]},{"title":"设备状态","data":[{...}]}]' \
  --output "/workspace/Document/PersonalDocuments/output.xlsx"
```

## 功能特性

| 特性 | 说明 |
|---|---|
| 自适应列宽 | 中文字符按 2.2 倍宽度计算，最小 8，最大 60 |
| 自适应行高 | 根据内容长度和列宽估算折行数，最高 120pt |
| 冻结首行 | 滚动时表头始终可见 |
| 自动筛选 | 表头自动加下拉筛选按钮 |
| 斑马纹 | 偶数行浅绿色背景，提升可读性 |
| 签名行 | 每个 sheet 末尾自动追加"以上内容由 ECclaw 生成" |

## 依赖说明

| 依赖包 | 版本 | 用途 |
|--------|------|------|
| openpyxl | 3.1.5 | Excel .xlsx 读写核心库 |
| et-xmlfile | 2.0.0 | openpyxl 底层 XML 支持 |

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