xlsx-writer

What problem does it solve?

Spreadsheets often lack structure and consistency, leading to errors, inconsistent formatting, and hard-to-maintain reports. This skill enforces a design-first approach to generate polished, production-ready Excel workbooks with KPI bands, tables, and standardized styling.

Core Features & Use Cases

• KPI bands with merged cells and theme-driven styling for executive summaries.
• Native OpenPyxl Tables with autofilter, banding, and preserved formatting on updates.
• Freeze panes, explicit column widths, and controlled row heights to ensure readable reports.
• Use Case: produce a six-sheet analytical workbook (Cover, Parameters, Detail per dimension, and Appendix) from raw data, then reuse the same blueprint for batch exports.

Quick Start

Start by creating a new workbook scaffold and populate a Cover sheet with KPI bands using the design tokens.