xlsx-modeling - Programmatic Excel Spreadsheet Modeling with openpyxl
Creates Excel spreadsheets programmatically using openpyxl, supporting worksheets, data, formulas, charts, formatting, and named ranges.
Tags
Updated: 2026-09-20Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Write cell data and Excel formulas
- Create and reference named ranges
- Apply cell formatting and styles
- Generate and configure Excel charts
- Set freeze panes and autofilters
- Manage worksheets and sheet order
- Stream write large Excel files
- Add conditional formatting rules
- Set data validation dropdown lists
- Protect worksheets with passwords
Inputs
- Python data structures
- Existing Excel files
Outputs
- Excel files (.xlsx)
- In-memory Excel binary streams
Requirements
- Python environment
- openpyxl library