Skip to main content
skill CX Codex

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

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add gasserane/personal-skills --skill office-repair -a claude-code
Open on GitHub

What 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 .docx or .xlsx to canonical status

Example prompts for the agent

  • 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

How to install office-repair

1Skills CLI (Vercel)

npx skills add gasserane/personal-skills --skill office-repair -a claude-code

2Manually: put the files in place

~/.claude/skills/office-repair/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/office-repair/

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.

Similar skills

All skills for Office documents →

From the same set44

The whole set →
tor-procurement tor-procurement — a Claude Code skill that drafts, audits, and formats procurement briefs for professional consulting engagements. Prepares formal tender requirements or evaluates existing drafts against audit benchmarks. CX Codex +1 290installs procurement-offer-review procurement-offer-review is a skill that checks a supplier's technical or financial offer against a ToR, writes evidence cards per requirement, and keeps procurement-pack decisions consistent. CX Codex +1 249installs linkedin-field-note linkedin-field-note — a skill for Claude Code runs an end-to-end editorial pipeline for personal AI Field Notes on LinkedIn, covering topic triage, dictation, kit generation, and posting. CX Codex +1 219installs donor-proposal-scoring donor-proposal-scoring — a skill for Claude Code scores grant proposals against a donor’s published criteria. It can check thresholds or compare its assessment with the donor’s evaluation report. CX Codex +1 182installs office-review-pass office-review-pass runs a .docx through a review cycle: reads other people's comments, writes findings back as margin notes, and applies Word tracked changes a counterparty can accept or reject. CX Codex +1 144installs selection-toolkit selection-toolkit is a Claude Code skill that builds Excel workbooks for selection and multi-criteria appraisal, with weighted scoring based on published criteria. CX Codex +1 135installs contract-delivery-kickoff contract-delivery-kickoff turns a signed supplier contract into a first-session pack: a workbook that totals days against the contracted ceiling, an internal brief, a supplier agenda and a note template. CX Codex +1 134installs literature The literature Claude Code skill searches scholarly works through OpenAlex. It runs to find sources, check whether a question has been studied, or map key papers. CX Codex +1 130installs

Project sponsors

Companies that keep this analytics open