office-repair — Claude Code skill: what it does, how to install
office-repair fixes complex Excel workbooks in place via COM without dropping slicers, or promotes hand-edited Office files to canonical sources.
no license 144 installs ★ 3 updated 2026-10-23
npx skills add gasserane/personal-skills --skill office-repair -a claude-codeWhat office-repair 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.
What it helps with
- 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
.docxor.xlsxto canonical status
Example prompts for the agent
- Scan
budget.xlsxfor broken formulas and circular dependencies - Apply cell fixes from
edits.jsontometrics.xlsxvia COM - Retire the generator script and promote
deck.pptxto canonical source
How to install office-repair
1Skills CLI (Vercel)
npx skills add gasserane/personal-skills --skill office-repair -a claude-code2Manually: put the files in place
~/.claude/skills/office-repair/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/office-repair/
1Skills CLI (Vercel)
npx skills add gasserane/personal-skills --skill office-repair -a codex2Manually: put the files in place
.agents/skills/office-repair/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add gasserane/personal-skills --skill office-repair -a cursor2Manually: put the files in place
.cursor/skills/office-repair/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install gasserane/personal-skills skills/office-repair2Manually: put the files in place
.github/skills/office-repair/SKILL.md1Skills CLI (Vercel)
npx skills add gasserane/personal-skills --skill office-repair -a gemini-cli2Platform CLI
gemini skills install https://github.com/gasserane/personal-skills --path skills/office-repairManually: put the files in place
.devin/skills/office-repair/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add gasserane/personal-skills --skill office-repair -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about office-repair
How do I install office-repair in Claude Code?
Run npx skills add gasserane/personal-skills --skill office-repair -a claude-code.
Why does the skill use COM instead of openpyxl?
Saving workbooks with openpyxl removes slicers, ListObject definitions, and sheet protections without alerting the user. The COM route invokes Excel directly to leave those features intact.
How are date cells updated during COM repairs?
Write the Excel day serial number directly to .Value2 and reapply NumberFormat. Passing standard date objects triggers UTC conversions that shift calendar days backward.