skills.rest
Jackiexiao
JackiexiaoCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

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

Updated Feb 20, 2026
Search Tags:#automation#reporting#data analysis#pandas#openpyxl#excel#xlsx
One-click install
npx skills add https://github.com/Jackiexiao/jackie-skills-cn-top50 --skill xlsx-jackiexiao
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Jackiexiao/jackie-skills-cn-top50/tree/main/skills/xlsx
Command: npx skills add https://github.com/Jackiexiao/jackie-skills-cn-top50 --skill xlsx-jackiexiao

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers you to create, edit, and analyze Excel files programmatically, eliminating manual spreadsheet work and ensuring data integrity.

Core Features & Use Cases

  • Dynamic Formula Generation: Create Excel files where formulas are used instead of hardcoded values, ensuring spreadsheets remain dynamic and updateable.
  • Data Analysis & Manipulation: Leverage pandas for powerful data manipulation, analysis, and visualization directly from Excel files.
  • Formula Recalculation & Error Checking: Utilize LibreOffice via scripts/recalc.py to recalculate all formulas, verify data integrity, and identify/fix common Excel errors (#REF!, #DIV/0!, etc.).
  • Use Case: Automate the generation of monthly financial reports by reading raw data, performing calculations using Excel formulas, and outputting a well-formatted, error-free report.

Quick Start

Use the xlsx skill to create a new Excel file named 'sales_report.xlsx' with columns 'Product', 'Quantity', and 'Price', and populate it with sample data.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel report generation with dynamic formulas instead of hardcoded values?▼

Automating Excel report generation with dynamic formulas involves using openpyxl and pandas to write formulas programmatically. This ensures spreadsheets remain updateable, recalculating values dynamically when source data changes.

How do I recalculate Excel formulas and check for errors like #REF! and #DIV/0! programmatically?▼

Recalculating Excel formulas and checking errors programmatically requires integrating LibreOffice to re-evaluate formulas and verify data integrity. This approach identifies and fixes common spreadsheet errors like #REF! and #DIV/0! automatically.

Can I use pandas and openpyxl to manipulate and format complex Excel files?▼

You can use pandas and openpyxl to manipulate and format complex Excel files. Pandas handles data analysis and manipulation, while openpyxl manages complex formatting, dynamic report generation, and formula insertion.

Do I need LibreOffice installed to use Excel automation for formula recalculation?▼

You need LibreOffice installed for Excel formula recalculation. The automation process utilizes LibreOffice via a recalculation script to re-evaluate all formulas, verify data integrity, and identify common spreadsheet errors.

What is the best way to automate monthly financial reports from raw Excel data?▼

Automating monthly financial reports is best achieved by reading raw data with pandas, performing calculations using Excel formulas, and outputting a well-formatted, error-free report via openpyxl to maintain data integrity.

Related Skills

Explore More Data & Analytics Skills→
ironkid90ironkid90

xlsx

Manage and analyze Excel files using pandas and openpyxl.

Community
Advanced
run6270run6270
1

Excel Analysis

Analyze and manipulate Excel spreadsheet data with pandas and openpyxl.

Community
Intermediate
pounctpounct

xlsx

Create and edit Excel spreadsheets with formulas using openpyxl and pandas.

Community
Advanced
vinayakgvinayakg

xlsx

Create and edit Excel files with formulas, formatting, and pandas analysis.

Community
Advanced