skill-spreadsheet

# Spreadsheet Skill

Thin wrapper that routes spreadsheet-to-table operations to the `spreadsheet-agent`.

## Context Pointers

Reference (do not load eagerly):
- Path: `.claude/context/formats/subagent-return.md`
- Purpose: Return validation
- Load at: Subagent execution only

Note: This skill is a thin wrapper. Context is loaded by the delegated agent, not this skill.

## Trigger Conditions

This skill activates when:

### Direct Invocation
- User explicitly runs `/table` command
- User requests spreadsheet to table conversion in conversation

### Implicit Invocation (during task implementation)

When an implementing agent encounters any of these patterns:

**Plan step language patterns**:
- "Convert spreadsheet to table"
- "Create LaTeX table from Excel"
- "Import data from XLSX"
- "Generate Typst table from CSV"
- "Extract table data from spreadsheet"

**File extension detection**:
- Source file has extension: `.xlsx`, `.xls`, `.csv`, `.ods`
- Target mentions: "LaTeX table", ".tex", "Typst table", ".typ"

**Task description keywords**:
- "spreadsheet conversion"
- "Excel to table"
- "data table"
- "tabular data"

### When NOT to trigger

Do not invoke for:
- Document conversions (use skill-filetypes)
- Presentation conversions (use skill-presentation)
- Reading spreadsheets without table generation
- Spreadsheets already in LaTeX/Typst format

---

## Execution

### 1. Input Validation

Validate required inputs:
- `source_path` - Must be provided and file must exist
- `output_path` - Optional, defaults to source dir with .tex extension
- `output_format` - Optional, defaults to "latex"

```bash
# Validate source exists
if [ ! -f "$source_path" ]; then
  return error "Source file not found: $source_path"
fi

# Validate source is spreadsheet format
source_ext="${source_path##*.}"
case "$source_ext" in
  xlsx|xls|csv|ods) ;; # Valid
  *) return error "Not a spreadsheet format: .$source_ext" ;;
esac

# Determine output path if not provided
if [ -z "$output_path" ]; then
  source_dir=$(dirname "$source_path")
  source_base=$(basename "$source_path" | sed 's/\.[^.]*$//')

  case "$output_format" in
    latex|tex) output_path="${source_dir}/${source_base}.tex" ;;
    typst|typ) output_path="${source_dir}/${source_base}.typ" ;;
    *) output_path="${source_dir}/${source_base}.tex" ;;
  esac
fi
```

### 2. Context Preparation

Prepare delegation context:

```json
{
  "source_path": "/absolute/path/to/data.xlsx",
  "output_path": "/absolute/path/to/data.tex",
  "output_format": "latex",
  "sheet_name": null,
  "metadata": {
    "session_id": "sess_{timestamp}_{random}",
    "delegation_depth": 1,
    "delegation_path": ["orchestrator", "table", "skill-spreadsheet"]
  }
}
```

### 3. Invoke Agent

**CRITICAL**: You MUST use the **Task** tool to spawn the agent.

**Required Tool Invocation**:
```
Tool: Task (NOT Skill)
Parameters:
  - subagent_type: "spreadsheet-agent"
  - prompt: [Include source_path, output_path, output_format, sheet_name, metadata]
  - description: "Convert {source_path} to {output_format} table"
```

The agent will:
- Detect available tools (pandas, openpyxl, xlsx2csv)
- Read spreadsheet data
- Generate formatted table output
- Return standardized JSON result

### 4. Return Validation

Validate return matches `subagent-return.md` schema:
- Status is one of: converted, partial, failed
- Summary is non-empty and <100 tokens
- Artifacts array present with output file path
- Metadata contains row/column counts

### 5. Return Propagation

Return validated result to caller without modification.

---

## Return Format

Expected successful return:
```json
{
  "status": "converted",
  "summary": "Successfully converted data.xlsx to LaTeX table using pandas",
  "artifacts": [
    {
      "type": "implementation",
      "path": "/absolute/path/to/data.tex",
      "summary": "LaTeX table with 5 columns, 100 rows"
    }
  ],
  "metadata": {
    "session_id": "sess_...",
    "agent_type": "spreadsheet-agent",
    "delegation_depth": 2,
    "tool_used": "pandas+openpyxl",
    "rows": 100,
    "columns": 5
  },
  "next_steps": "Include table in document"
}
```

---

## Error Handling

### Input Validation Errors
Return immediately with failed status if source file not found or not a spreadsheet.

### Unsupported Format
Return failed status with clear message about supported formats.

### Agent Errors
Pass through the agent's error return verbatim.

### Tool Not Available
Return failed status with installation instructions.