claudegoodies
Skill

officecli-xlsx

From iOfficeAI

Use this skill any time a .xlsx file is involved -- as input, output, or both. This includes: creating spreadsheets, financial models, dashboards, or trackers; reading, parsing, or extracting data from any .xlsx file; editing, modifying, or updating existing workbooks; working with formulas, charts, pivot tables, or templates; importing CSV/TSV data into Excel format. Trigger whenever the user mentions 'spreadsheet', 'workbook', 'Excel', 'financial model', 'tracker', 'dashboard', or references a .xlsx/.csv filename.

Drives the officecli command-line tool to create, read, and edit .xlsx workbooks with formulas, formatting, and charts.

Use it when

  • Building financial models, dashboards, or trackers from scratch
  • Reading or extracting data from an existing .xlsx file
  • Editing formulas, cell formatting, pivot tables, or charts in a workbook
  • Importing CSV/TSV data into Excel format

Skip it if

  • Requires installing and relying on a third-party CLI (officecli) not built into Claude
  • Needs manual shell quoting discipline for paths/formats containing $ and []
  • Only useful when a .xlsx file is actually involved, not general spreadsheet logic

Facts

Repository
iOfficeAI/OfficeCLI
Status
Actively maintained
Last commit
Source file
skills/officecli-xlsx/SKILL.md

Source preview

The instructions Claude Code reads when this skill runs.

# OfficeCLI XLSX Skill

## Setup

If `officecli` is missing:

- **macOS / Linux**: `curl -fsSL https://d.officecli.ai/install.sh | bash`
- **Windows (PowerShell)**: `irm https://d.officecli.ai/install.ps1 | iex`

Verify with `officecli --version` (open a new terminal if PATH hasn't picked up). If install fails, download a binary from https://github.com/iOfficeAI/OfficeCLI/releases.

## ⚠️ Help-First Rule

**This skill teaches what good xlsx looks like, not every command flag. When a property name, enum value, or alias is uncertain, consult help BEFORE guessing.**

```bash
officecli help xlsx                         # List all xlsx elements
officecli help xlsx <element>               # Full element schema (e.g. pivottable, chart, cf)
officecli help xlsx <verb> <element>        # Verb-scoped (e.g. add chart, set cell)
officecli help xlsx <element> --json        # Machine-readable schema
```

Help reflects the installed CLI version. When this skill and help disagree, **help is authoritative**.

## Shell & Execution Discipline

**Shell quoting (zsh / bash).** Excel paths contain `[]`, and number formats contain `$`. Both are shell metacharacters. Rules:

- ALWAYS quote element paths: `"/Sheet1/row[1]"`, not `/Sheet1/row[1]`.
- Use **single quotes** for any prop value containing `$`: `numFmt='$#,##0'`.
- For formulas with cross-sheet `!` references, use `batch` with a `<<'EOF'` here
View full source on GitHub →

Other skills