excel-export-validator

This validator acts as a rigorous quality assurance layer for the Customer Feedback Analyzer Excel export pipeline. Designed for data engineers and product analysts, it automates the verification of complex workbook structures to ensure that every customer-facing file meets exact schema and formatting requirements. By integrating Python-based assertions using openpyxl, it prevents common regressions in report generation, such as missing sheets, column mismatches, or incorrect tab styling, which are critical for executive-level reporting.

The skill provides automated validation for the following capabilities:

• Systematic sheet structure verification for 7 distinct view sheets, ranging from Management Dashboards to Duplicate Analysis tabs.
• Strict enforcement of a 36-column schema in the primary Calculated Data sheet, verifying data integrity across primary review, secondary analysis, and duplicate detection groupings.
• Automated check of professional tab color schemes (RGB format), ensuring specific business logic (e.g., urgency levels) is visually represented by tab colors like red, orange, and blue.
• Validation of data consistency, including filter-specific logic per sheet to maintain the integrity of exported metrics.
• Detection of formula or structure discrepancies, providing immediate feedback before the export is released to stakeholders.

Practical implementation notes for users:

• Inputs: Expects a standard .xlsx export file generated by the Customer Feedback Analyzer.
• Process: The validator maps the actual workbook contents against expected sheet names, ordering, and column headers.
• Outputs: Provides explicit error reports for any missing sheets or schema violations, ensuring 'Zero Errors' in final deliverables.
• Constraints: Requires the openpyxl library for all validation logic; does not support legacy .xls formats.
• Best practices: Run this check during local development, CI/CD pipelines, or as a post-generation smoke test to maintain quality assurance standards for customer-facing documents.