XLSX Surgery

The physics of surgically editing an existing Excel/xlsx (OOXML) file. Use when you must change a few cells or structures in a workbook that already exists while leaving everything else byte-identical — formulas, styles, charts, pivot tables, external links. Covers why library round-trips silently corrupt parts you never touched, how to make minimal string/ZIP-level incisions, the five file-level landmines that real Excel refuses to open but permissive tools show as fine, and the streaming rules for reading hundred-megabyte worksheets without exhausting memory (the 50x memory law, on-disk point lookups, never materialize a whole sheet).

poloplay0114 Updated 1 repo stars

File contents

poloplay0114/hard-won-claude-skills commit 4f55c46bc6

Frequently asked questions

npx get-skill add poloplay0114/xlsx-surgery