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".

Источник