skills sourced live from GitHub · all skills listed are free · each skill is provided under its author's license.
home / Document Processing / Xlsx Manipulation Skill by @claude-office-skills
The skill is the xlsx-manipulation folder inside that repository. Copy it into the folder your agent loads skills from; check your agent's documentation for where that is.
Creates and edits Excel workbooks in code with openpyxl: formulas, formatting, charts and data validation.
Introduces workbook structure and cell handling, then shows how to build professional spreadsheets without manual editing. Good for repeatable report generation.
The original SKILL.md is organised into these sections:
Written and maintained by @claude-office-skills. It is published under the MIT license, which allows reuse with attribution. See the author profile. SkillDirectory does not claim authorship: this page adds our own review and links back to the original, and the skill's text belongs to its author.
# 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 ```python from openpyxl import Workbook, load_workbook from openpyxl.styles import Font, Fill, Border, Alignment from openpyxl.chart import BarChart, Reference # Create new workbook wb = Workbook() ws = wb.active # Or open existing …
Excerpt only, quoted from the author's repository. Open the repository for the complete file.