Spreadsheet Workbook Forensics

Use this skill for workbook edits where preserving structure and verifying target cells matters.

Workflow

1. Inspect the actual workbook, not only a preview: sheet names, dimensions, merged cells, headers, formulas, named ranges, and nearby examples.
2. Locate source tables and destination ranges by labels, headers, surrounding structure, and requested ranges, not fixed coordinates unless explicitly given.
3. Write a small script with INPUT_PATH and OUTPUT_PATH constants.
4. Use openpyxl for structure-preserving read/write. Use pandas only for in-memory transformation, then write back with openpyxl.
5. Execute the script.
6. Reopen the saved workbook and verify representative and boundary target cells.

Workbook Rules