skills.rest
epiphanyapps
epiphanyappsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

xlsx

Creates, edits, and analyzes Excel files (.xlsx, .csv, .tsv) with pandas and openpyxl, verifying formulas via Lua脚本.

Updated Jan 17, 2026
Search Tags:#reporting#data analysis#pandas#openpyxl#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/epiphanyapps/mapyourhealth --skill xlsx-epiphanyapps
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/epiphanyapps/mapyourhealth/tree/main/apps/mobile/.agents/skills/xlsx
Command: npx skills add https://github.com/epiphanyapps/mapyourhealth --skill xlsx-epiphanyapps

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, python-docx, python-pptx, lxml, defusedxml, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines your spreadsheet tasks, from creating new files and editing existing ones to performing complex data analysis and ensuring formula accuracy.

Core Features & Use Cases

  • File Creation & Editing: Generate new .xlsx files or modify existing ones, including adding columns, updating data, and applying formatting.
  • Data Analysis: Leverage pandas for powerful data manipulation, analysis, and visualization directly from Excel files.
  • Formula Management: Ensure all formulas are error-free and correctly implemented using Excel's native functions. The scripts/recalc.py script is used to verify and fix formula errors.
  • Use Case: Automatically update a sales report (sales_data.xlsx) by adding new quarterly figures, calculating year-over-year growth percentages, and formatting the output professionally.

Quick Start

Use the xlsx skill to read the data from the attached file 'quarterly_report.xlsx' and print the first five rows.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel data analysis and editing using Python?▼

Automating Excel data analysis and editing is handled by this Skill using Python libraries like pandas and openpyxl to read, modify, and analyze spreadsheet files programmatically.

Can I add columns and compute formulas in an existing xlsx file?▼

You can add columns and compute formulas in an existing xlsx file by modifying the data with pandas or openpyxl, ensuring zero formula errors through native Excel functions and recalculation validation.

Does this approach support converting between CSV, TSV, and xlsx formats?▼

Yes, this approach supports converting between tabular formats like .xlsx, .xlsm, .csv, and .tsv by leveraging Python data manipulation libraries to transform and export the files.

What is the best way to clean messy spreadsheet data?▼

The best way to clean messy spreadsheet data here is using pandas for powerful data manipulation, allowing you to handle inconsistencies and format the output professionally.

How do you ensure Excel formulas have zero errors after recalculation?▼

Ensuring zero formula errors during Excel recalculation is achieved by using a dedicated validation script with LibreOffice to verify and fix formula errors automatically.

Related Skills

Explore More Data & Analytics Skills→
OpenCoworkAIOpenCoworkAI
2.0k

xlsx

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

Official
Advanced
dirnbauerdirnbauer
33

document-processing

Create, extract from, and analyze PDF, DOCX, PPTX, and XLSX office documents using Python and JavaScript libraries.

Community
Advanced
ARAVINDAN20ARAVINDAN20
4

docx

Automate Word DOCX creation, editing, and analysis in Python.

Community
Advanced
patriotnewsactivismpatriotnewsactivism
2

excel-generator

Generate Excel spreadsheets with formatting, formulas, charts, and data validation.

Community
Advanced