skills.rest
az9713
az9713COMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze Excel workbooks with formulas and formatting.

Updated Oct 19, 2025
Search Tags:#automation#data analysis#pandas#openpyxl#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/az9713/claude_skill_hn_mcp_server --skill xlsx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/az9713/claude_skill_hn_mcp_server/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/az9713/claude_skill_hn_mcp_server --skill xlsx

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, and includes scripts (resource) components.

What problem does it solve?

Manually creating, updating, and analyzing complex Excel spreadsheets is prone to errors and extremely time-consuming. This Skill automates all aspects of spreadsheet management, from dynamic formula creation to data analysis and error-free recalculations, ensuring accuracy and saving countless hours.

Core Features & Use Cases

  • Dynamic Spreadsheet Generation: Create new Excel files with complex formulas, formatting, and data, ensuring they remain dynamic and recalculable.
  • Intelligent Data Analysis: Read, analyze, and modify existing spreadsheets using powerful data manipulation libraries like pandas, preserving existing formulas and formatting.
  • Automated Formula Recalculation & Validation: Recalculate all formulas and automatically detect common Excel errors (e.g., #REF!, #DIV/0!) to ensure data integrity.
  • Use Case: A financial analyst needs to generate monthly reports that pull data from various sources, apply complex financial models, and present results in a standardized, error-free Excel format. This Skill can automate the entire report generation, recalculation, and validation process, freeing the analyst to focus on insights.

Quick Start

Example: Create a new Excel file with a formula

from openpyxl import Workbook

wb = Workbook() sheet = wb.active

Add data and a formula

sheet['A1'] = 10 sheet['A2'] = 20 sheet['A3'] = '=SUM(A1:A2)' # Excel will calculate this

Save the workbook

wb.save('my_report.xlsx')

CRITICAL: Recalculate formulas using the provided script

This step ensures all formulas are evaluated and errors are caught.

python recalc.py my_report.xlsx

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 with formulas and formatting?▼

Automate Excel spreadsheet creation using openpyxl to programmatically add formulas, data, and formatting, then recalculate formulas with the provided recalc.py workflow to ensure accuracy and catch errors like #REF! or #DIV/0!.

Can I read and modify existing Excel files while preserving formulas?▼

Yes, pandas and openpyxl enable intelligent data analysis and modification of existing spreadsheets while preserving formulas and formatting, allowing you to update data without disrupting calculations.

What's the best way to generate dynamic financial reports in Excel?▼

Create dynamic financial reports by building Excel workbooks with complex formulas and data transformations using openpyxl and pandas, then validate and recalculate all formulas to ensure zero errors before delivery.

How do I detect and fix formula errors in Excel files?▼

The Skill's recalc.py workflow automatically recalculates all formulas and detects common Excel errors, enforcing data integrity and preventing formula calculation failures in your workbooks.

Can I use this to analyze spreadsheet data with Python?▼

Yes, leverage pandas alongside openpyxl to read, analyze, and manipulate Excel data within Python, enabling programmatic data analysis while maintaining spreadsheet structure and formulas.

Do I need LibreOffice installed to recalculate formulas?▼

The Skill supports LibreOffice-based formula recalculation via the recalc.py workflow, which handles complex formula evaluation and ensures all calculations update correctly across your workbooks.

Related Skills

Explore More Finance & Accounting Skills→
OpenCoworkAIOpenCoworkAI
2.0k

xlsx

Create and edit Excel workbooks with formulas across .xlsx, .xlsm, .csv, and .tsv formats.

Official
Advanced
Duzhenyang111Duzhenyang111

audit-xls

Validate Excel workbooks for formula errors and structural flaws using Python.

Community
Advanced
zihan987zihan987
1

Excel Analysis

Analyze and visualize Excel data with pandas, openpyxl, and matplotlib.

Community
Intermediate
skycruzerskycruzer

XLSX

Automates Excel spreadsheet creation, editing, and pandas-based analysis with LibreOffice recalculation.

Community
Intermediate