| name | openpyxl |
| description | Create and manipulate Microsoft Excel workbooks programmatically. Build spreadsheets with formulas, charts, conditional formatting, and pivot tables. Handle large datasets efficiently with streaming mode. |
| version | 1.0.0 |
| category | data |
| type | skill |
| capabilities | ["workbook_creation","cell_formatting","formula_support","chart_generation","conditional_formatting","pivot_tables","large_dataset_handling","streaming_mode"] |
| tools | ["python","openpyxl","pandas"] |
| tags | ["excel","xlsx","spreadsheet","formulas","charts","data-analysis","office-automation"] |
| platforms | ["windows","macos","linux"] |
| related_skills | ["pandas-data-processing","python-docx","plotly"] |
| requires | [] |
| scripts_exempt | true |
Openpyxl
Overview
Openpyxl is a Python library for reading and writing Excel 2010+ xlsx/xlsm files. This skill covers comprehensive patterns for spreadsheet automation including:
- Workbook creation with multiple worksheets
- Cell operations including formatting, merging, and data validation
- Formula support for calculations and dynamic content
- Chart generation for data visualization within Excel
- Conditional formatting for visual data analysis
- Large dataset handling with optimized read/write modes
- Pivot table creation for data summarization
- Style management for professional appearances
When to Use This Skill
USE when:
- Creating Excel reports with formulas and calculations
- Generating spreadsheets from database queries
- Automating financial reports and dashboards
- Building Excel templates with formatting
- Processing and transforming existing Excel files
- Creating charts and visualizations in Excel
- Applying conditional formatting rules
- Building data entry forms with validation
- Handling large datasets (100k+ rows)
- Creating pivot tables programmatically
DON'T USE when:
- Only need to read data into pandas (use pandas.read_excel directly)
- Need real-time Excel manipulation (use xlwings on Windows)
- Working with .xls format (use xlrd/xlwt)
- Creating complex macros (requires VBA)
- Need Excel-specific features like Power Query
Prerequisites
Installation
pip install openpyxl
uv pip install openpyxl
pip install openpyxl Pillow
*See sub-skills for full details.*
```python
from openpyxl import Workbook, load_workbook
from openpyxl.styles import Font, PatternFill, Alignment, Border
from openpyxl.chart import BarChart, LineChart, PieChart
from openpyxl.utils.dataframe import dataframe_to_rows
print("openpyxl installed successfully!")
Version History
