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