Audit your Excel pivot tables before they break — a read-only CLI with zero dependencies

说明与用途

pivot‑diag 是一个只读 CLI，用于在刷新前审计 Excel 透视表配置，检测重叠位置、重叠来源、共享来源、缺失来源工作表等问题。

问题

Excel workbooks with multiple pivot tables often break when a refresh causes overlapping placements or source ranges, or when a pivot references a renamed/deleted sheet.

结果

pivot‑diag detects problematic pivot configurations before a refresh, preventing runtime errors and saving users time in troubleshooting.

工作流

• 1. Install pivot‑diag (no dependencies).
• 2. Run pivot-diag <workbook.xlsx> from the command line.
• 3. The tool parses the OOXML parts xl/pivotCache/pivotCacheDefinitionN.xml and xl/pivotTables/pivotTableN.xml using Python’s standard library.
• 4. It outputs a report listing any overlapping locations, overlapping sources, shared sources, missing source sheets, and informational notes.
• 5. Review the report and correct the pivot configurations in Excel accordingly.

证据

pivot‑diag parses these parts directly with zipfile + ElementTree.

来源

Scenario 3 is the one that matters most in practice: a pivot that references a renamed or deleted sheet is a landmine that only explodes when someone clicks "Refresh".

来源