Agent skill · software engineering · claude-office-skills
xlsx-manipulation
Create, edit, and manipulate Excel spreadsheets programmatically using openpyxl
Why this skill is useful
Provides specific commands and patterns for manipulating Excel spreadsheets using openpyxl that the AI wouldn't reliably generate on its own.
What it needs
Requires openpyxl installed locally. About 5k tokens when loaded. Last updated 2026-01-31. 363 stars on the source repository.
What this skill does
XLSX Manipulation Skill Overview This skill enables programmatic creation, editing, and manipulation of Microsoft Excel (.xlsx) spreadsheets using the openpyxl library. Create professional spreadsheets with formulas, formatting, charts, and data validation without manual editing. How to Use 1. Describe the spreadsheet you want to create or modify 2. Provide data, formulas, or formatting requirements 3. I'll generate openpyxl code and execute it Example prompts: "Create a budget spreadsheet with monthly tracking" "Add conditional formatting to highlight values above threshold" "Generate a pivot-table-like summary from this data" "Create a dashboard with charts and KPIs" Domain Knowledge openpyxl Fundamentals Workbook Structure Working with Cells Basic Cell Operations Reading Cells Formulas Formatting Cell Styles Number Formats Conditional Formatting Charts Data Validation Sheet Operations Row/Column Operations Best Practices 1. Use Templates: Start with a .xlsx template for complex formatting 2. Batch Operations: Minimize cell-by-cell operations for speed 3. Named Ranges: Use defined names for clearer formulas 4. Data Validation: Add validation to prevent input errors 5. Save Incrementally: For large files, save periodically Common Patterns Data Import Report Template Examples Example 1: Budget Tracker Example 2: Sales Dashboard Limitations Cannot execute VBA macros Complex pivot tables not fully supported Limited sparkline support External data connections not supported Some advanced chart types unavailable Installation Resources openpyxl Documentation GitHub Repository Working with Styles
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills claude-office-skills/xlsx-manipulation