skills.rest
Weiwei-Mao
Weiwei-MaoCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

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

2|Updated Feb 2, 2026
Search Tags:#data analysis#pandas#openpyxl#formulas#spreadsheet#excel#recalculation
One-click install
npx skills add https://github.com/Weiwei-Mao/hydrology-skills --skill xlsx-weiwei-mao
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Weiwei-Mao/hydrology-skills/tree/main/hydrology-skills/xlsx
Command: npx skills add https://github.com/Weiwei-Mao/hydrology-skills --skill xlsx-weiwei-mao

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet files, ensuring data integrity and dynamic calculations.

Core Features & Use Cases

  • Formula Management: Create, edit, and recalculate complex formulas within Excel files, ensuring accuracy and preventing errors.
  • Data Analysis & Visualization: Utilize pandas for robust data manipulation and analysis, and openpyxl for detailed formatting and structure.
  • Use Case: Automatically generate a financial projection spreadsheet, populate it with historical data, add formulas for growth rates and totals, and then use the recalc.py script to verify all calculations and error-free output.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add a formula in the 'Revenue' column to sum the values.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create an Excel spreadsheet and ensure formulas recalculate correctly?▼

To create an Excel spreadsheet and ensure formulas recalculate correctly, use openpyxl to build and edit formulas, then run the recalc.py script via LibreOffice to verify calculations and generate error-free output.

Can I use pandas for data analysis and manipulation on existing Excel files?▼

Yes, you can use pandas for robust data analysis and manipulation on existing .xlsx and .xlsm files, enabling data summarization and report generation while maintaining formatting and formula integrity through openpyxl.

What is the best way to automate financial modeling and report generation in Excel?▼

Automating financial modeling and report generation is best handled by combining pandas for data manipulation with openpyxl for structure, then using LibreOffice recalculation to verify formula integrity.

Does this approach support CSV and TSV files alongside standard Excel formats?▼

Yes, this approach supports CSV and TSV files alongside standard .xlsx and .xlsm Excel formats, providing detailed error reporting for spreadsheets while adhering to strict formatting and formula integrity standards.

Why do my spreadsheet formulas break when I edit XLSX files with Python?▼

Spreadsheet formulas often break when editing XLSX files because standard Python libraries do not recalculate them, requiring LibreOffice integration to verify dynamic calculations and prevent formula integrity errors.

Related Skills

Explore More Data & Analytics Skills→
cbbkrd-techcbbkrd-tech

xlsx

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.

Community
Advanced
fantay0312fantay0312

xlsx

Create and edit Excel spreadsheets with formulas via LibreOffice recalculation.

Community
Advanced
OpenSenseNovaOpenSenseNova
4.9k

group-by-analysis

Automates Excel data grouping, summarization, and visualization across multiple sheets.

Official
Intermediate
ChatAndBuildChatAndBuild
1

xlsx

Automate Excel spreadsheet creation, editing, and analysis with pandas and openpyxl.

Official
Advanced