xlsx-manipulation

The xlsx-manipulation skill enables users to create, edit, and manipulate Microsoft Excel (.xlsx) spreadsheets programmatically using the openpyxl library. It is designed to automate spreadsheet workflows that would otherwise require manual editing in Excel, helping users generate structured workbooks, apply formulas, format cells, and organize data efficiently. By leveraging Python-based spreadsheet operations, the skill supports repeatable and scalable spreadsheet generation for reporting, tracking, and analysis tasks.

The skill includes capabilities for spreadsheet creation, formula handling, and chart generation. Users can work with workbooks, worksheets, cells, rows, columns, named ranges, and charts while applying formatting such as fonts, borders, fills, alignment, and number formats. It supports common spreadsheet operations including appending rows, iterating through cell ranges, reading and updating cell values, and applying formulas like SUM, AVERAGE, and IF statements. The skill also integrates with MCP tools such as read_xlsx, create_xlsx, apply_formula, and create_chart to streamline spreadsheet automation workflows.

This skill is useful for analysts, business teams, finance departments, operations staff, and developers who need to automate spreadsheet creation or modification. Common use cases include generating budget trackers, KPI dashboards, formatted reports, data summaries, and chart-based visualizations. It is also suitable for users who want to build spreadsheet workflows programmatically without relying on manual Excel editing.