openpyxl
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:
More from vamseeachanta/workspace-hub
echarts
Create powerful interactive charts with Apache ECharts - balanced ease-of-use
139gis
Cross-application GIS skill — CRS reference, data formats, Blender/QGIS integration via digitalmodel.gis
80pandoc
Universal document converter for transforming Markdown to PDF, DOCX, HTML, LaTeX, and 40+ other formats. Covers templates, filters, citations with BibTeX/CSL, and batch conversion automation scripts.
74mkdocs
Build professional project documentation with MkDocs and Material theme.
73cli-productivity
Essential CLI tools and shell productivity patterns for efficient terminal workflows
55python-docx
Create and manipulate Microsoft Word documents programmatically. Build reports, contracts, and documentation with full control over paragraphs, tables, headers, styles, and images.
50