skills.rest
zeroix07
zeroix07COMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, analyze, and convert Excel files with Python and openpyxl.

Updated May 30, 2026
Search Tags:#automation#data analysis#openpyxl#spreadsheet#excel#pivot table#vba
One-click install
npx skills add https://github.com/zeroix07/mcp-skill-agent --skill xlsx-zeroix07
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/zeroix07/mcp-skill-agent/tree/main/xlsx
Command: npx skills add https://github.com/zeroix07/mcp-skill-agent --skill xlsx-zeroix07

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manual spreadsheet creation, editing, and analysis are time-consuming and prone to human error, especially with large datasets, complex formulas, or strict formatting requirements. This Skill eliminates those bottlenecks by providing an AI-powered workbench that handles everything from simple data entry to advanced financial modeling.

Core Features & Use Cases

  • Comprehensive Spreadsheet Lifecycle: Create new Excel files from scratch, edit existing workbooks while preserving styles and VBA macros, analyze data with pandas, and convert between CSV, JSON, PDF, and XLSX formats.
  • Enterprise-Grade Quality Assurance: A mandatory integrity pipeline with formula recalculation, error scanning, structural validation, and cross-sheet reference checking ensures every deliverable is production-ready.
  • Professional Design System: Twelve visual style palettes, cross-platform font resolution, and consistent layout rules produce polished, presentation-ready tables without manual formatting effort.
  • Specialized Workflows: Built-in scenes for financial modeling (DCF, LBO, three-statement models), VBA macro generation, batch processing of large files, and interactive PivotTable creation.

Quick Start

Use the xlsx skill to analyze the sales data in 'q4_report.csv' and generate a formatted Excel workbook with summary charts.

Frequently Asked Questions about xlsx

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Excel spreadsheet creation and analysis with Python?▼

Automate Excel spreadsheet creation and analysis using Python and openpyxl to programmatically generate workbooks, apply styles, and manipulate data without manual entry.

What is the best way to convert CSV or JSON files into formatted Excel workbooks?▼

Convert CSV and JSON files into formatted Excel workbooks by leveraging Python and pandas for data processing, then outputting styled XLSX files with consistent layout rules.

Can I edit existing Excel files and preserve VBA macros?▼

Edit existing Excel files while preserving VBA macros by using openpyxl to load .xlsm workbooks, update data or styles, and save without stripping the embedded macro code.

Do I need LibreOffice to recalculate Excel formulas when processing spreadsheets?▼

You need LibreOffice to recalculate Excel formulas during spreadsheet processing, as it enforces a strict quality pipeline to audit, scan, and validate computed cell values.

How do I generate financial models like DCF or LBO directly in Excel?▼

Generate financial models like DCF or LBO directly in Excel by applying built-in specialized workflows that structure three-statement models and automate complex formula calculations.

Does openpyxl support creating interactive PivotTables for data analysis?▼

openpyxl supports interactive PivotTables for data analysis by programmatically configuring data source ranges and summary dimensions to render dynamic views within the Excel workbook.

Related Skills

Explore More Data & Analytics Skills→
safzanpiranisafzanpirani
1

xlsx

Create, edit, and analyze Excel files with pandas and openpyxl.

Community
Advanced
tamnguyentommy-rgbtamnguyentommy-rgb
2

excel-generator

Generate and format Excel workbooks with formulas, charts, and data validation.

Community
Advanced
Wesley1600Wesley1600

Python Script Skill Template

Executes Python scripts that process CLI input and return JSON-formatted results.

Community
Basic
koolamusickoolamusic
9

xlsx

Create and edit Excel workbooks with formula validation via LibreOffice recalculation.

Community
Advanced