mcpField
O
openpyxl

openpyxl

github.com/vamseeachantaDocuments1844 installsUpdated today
Repository

About openpyxl

A skill for using openpyxl to automate Excel 2010+ workbooks, aimed at spreadsheet and report workflows. It covers workbook construction, formatting, formulas, charts, and large-data processing.

Key features

  1. 01Create workbooks with multiple sheets
  2. 02Format cells and merge ranges
  3. 03Use formulas and data validation
  4. 04Generate charts and conditional formatting
  5. 05Process large datasets and create pivot tables

Use cases

  1. 01Generate financial reports and dashboards
  2. 02Build formatted Excel templates
  3. 03Transform existing Excel files
  4. 04Visualize spreadsheet data with charts

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/vamseeachanta/workspace-hub --skill openpyxl

After installing, type/openpyxlin Claude Code to confirm it loaded.

Details

From the project README

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
# Basic installation
pip install openpyxl

# Using uv (recommended)
uv pip install openpyxl

# With image support
pip install openpyxl Pillow


*See sub-skills for full details.*
### Verify Installation

```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

1.0.0 (2026-01-17)
  • Initial skill creation
  • Core capabilities documentation
  • 6 complete code examples
  • Large dataset handling patterns
  • Integration with pandas

Resources

Related Skills

  • pandas-data-processing - Data analysis and transformation
  • python-docx - Word document generation
  • plotly - Interactive chart generation
  • pypdf - PDF manipulation

This skill provides comprehensive patterns for Excel automation refined from production data processing systems.

Sub-Skills

Comments

Markdown supported