skill-spreadsheet

Spreadsheet Skill

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

Context Pointers

Reference (do not load eagerly):

• Path: .opencode/context/core/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"

# 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:

{
  "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:

{
  "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.