# office-repair

office-repair fixes complex Excel workbooks in place via COM without dropping slicers, or promotes hand-edited Office files to canonical sources.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 144 installs · ★ 3 repo stars
- Author: gasserane
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/gasserane/personal-skills/tree/HEAD/skills/office-repair/SKILL.md
- Updated: 2026-10-23
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/office-repair

## What it does

The skill manages Office files that became the source of truth after manual editing. When an Excel workbook breaks, simple scripts based on `openpyxl` often wipe out slicers, sheet protections, and structured tables on save. To prevent data corruption, this tool inspects and alters files directly via Excel COM automation.

All modifications run through `scripts/office_repair.py` alongside `ane_package.officeops`. The workflow starts with a read-only scan to detect broken formulas, fragmented dropdown validation rules, and circular calculations. Edits are supplied as a JSON payload that guards against stale cell contents, rolls out a timestamped backup, and tests the workbook inventory after writing. Without a local Excel installation capable of COM interaction, the repair step cannot run.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add gasserane/personal-skills --skill office-repair -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/office-repair/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/office-repair/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add gasserane/personal-skills --skill office-repair -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/office-repair/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add gasserane/personal-skills --skill office-repair -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/office-repair/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install gasserane/personal-skills skills/office-repair
```

2. **Manually: put the files in place**
- File: `.github/skills/office-repair/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add gasserane/personal-skills --skill office-repair -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/gasserane/personal-skills --path skills/office-repair
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/office-repair/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add gasserane/personal-skills --skill office-repair -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/gasserane/personal-skills/tree/HEAD/skills/office-repair/SKILL.md

## When to use it
- resolve `#REF!` errors and circular calculations in complex workbooks
- restore fragmented data validation ranges after row insertions
- preserve slicers and sheet protection during targeted cell updates
- promote a hand-edited `.docx` or `.xlsx` to canonical status

## Example prompts
- Scan `budget.xlsx` for broken formulas and circular dependencies
- Apply cell fixes from `edits.json` to `metrics.xlsx` via COM
- Retire the generator script and promote `deck.pptx` to canonical source

## Similar
- [office](https://affpapa.org/en/nevibecode/skills/office.md) — skill · ★ 171 repo stars
- [office-productivity](https://affpapa.org/en/nevibecode/skills/office-productivity.md) — skill · 1600 installs
- [office-oxide-mcp](https://affpapa.org/en/nevibecode/mcp/office-oxide-mcp.md) — MCP server · ★ 165 repo stars
- [document-processing](https://affpapa.org/en/nevibecode/skills/document-processing.md) — skill · 1300 installs
- [xlsx-manipulation](https://affpapa.org/en/nevibecode/skills/xlsx-manipulation.md) — skill · 6900 installs
- [excel-automation](https://affpapa.org/en/nevibecode/skills/excel-automation.md) — skill · 1500 installs

From the same set: [gasserane/personal-skills](https://affpapa.org/en/nevibecode/by/gasserane/personal-skills.md) — 44 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
