skills.rest
mfmezger
mfmezgerCOMMUNITY
Explore all skills by this author →
Website𝕏@mfmezgerGitHub

xlsx

Create, edit, and analyze spreadsheet files using pandas and openpyxl.

5|Updated Feb 2, 2026
Search Tags:#automation#data analysis#pandas#openpyxl#spreadsheet#excel#formula
One-click install
npx skills add https://github.com/mfmezger/ai_agent_dotfiles --skill xlsx-mfmezger
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/mfmezger/ai_agent_dotfiles/tree/main/shared/skills/xlsx
Command: npx skills add https://github.com/mfmezger/ai_agent_dotfiles --skill xlsx-mfmezger

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill automates the creation, editing, and analysis of spreadsheet files, eliminating manual data manipulation and complex formula errors.

Core Features & Use Cases

  • Data Analysis: Use pandas for powerful data manipulation, cleaning, and visualization.
  • Formula Management: Leverage openpyxl to create and edit Excel files, ensuring formulas are correctly implemented and validated.
  • Workflow Automation: Streamline tasks like adding columns, computing formulas, formatting data, and converting between tabular formats.
  • Use Case: Automatically update a sales report by adding new data, calculating quarterly growth rates using Excel formulas, and ensuring no formula errors exist before saving the file.

Quick Start

Use the xlsx skill to read the attached file 'sales_data.xlsx' and calculate the total revenue for each region.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel formula calculation and avoid errors in existing spreadsheets?▼

Automating Excel formula calculation requires using openpyxl to edit formulas and LibreOffice to recalculate them, ensuring zero formula errors and preserving existing templates before saving the updated spreadsheet file.

Can I clean messy data and add computed columns to an xlsx file using pandas?▼

You can clean messy data and add computed columns to an xlsx file by using pandas for data manipulation and openpyxl for writing the updates, ensuring formatting and formulas are correctly applied to the spreadsheet.

What is the best way to convert between csv, tsv, and xlsx tabular formats?▼

The best way to convert between csv, tsv, and xlsx tabular formats is using an automation script that leverages pandas to read the source data and openpyxl to write the output, maintaining data integrity across formats.

Do I need LibreOffice installed to recalculate Excel formulas in openpyxl?▼

Yes, you need LibreOffice installed to recalculate Excel formulas, because openpyxl writes formulas but does not compute them natively, requiring the recalc script to evaluate formula values accurately.

How does spreadsheet workflow automation handle template preservation when updating files?▼

Spreadsheet workflow automation handles template preservation by using openpyxl to load and modify only specific cells or columns, ensuring the original formatting and structure remain intact when saving the updated file.

Can I generate charts and apply formatting directly to spreadsheet cells programmatically?▼

You can generate charts and apply formatting directly to spreadsheet cells programmatically by using openpyxl to manipulate the file structure, adding visual elements and styles without manual spreadsheet editing.

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
rangerrick337rangerrick337
10

xlsx

Automate Excel spreadsheet creation, editing, and analysis with formula integrity across .xlsx, .xlsm, .csv, and .tsv.

Community
Advanced
patriotnewsactivismpatriotnewsactivism
2

excel-generator

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

Community
Advanced
jsolarzjsolarz

xlsx

Create, edit, and analyze Excel spreadsheets with formula recalculation.

Community
Advanced