skills.rest
Rheasilvia
RheasilviaCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, read, and edit Excel workbooks and CSV files with formula recalculation.

Updated Jun 25, 2026
Search Tags:#automation#financial modeling#excel#xlsx#data cleaning#spreadsheets
One-click install
npx skills add https://github.com/Rheasilvia/hermes-desktop --skill xlsx-rheasilvia
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Rheasilvia/hermes-desktop/tree/main/skills/productivity/xlsx
Command: npx skills add https://github.com/Rheasilvia/hermes-desktop --skill xlsx-rheasilvia

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill solves the challenge of programmatically creating, editing, and validating complex Excel workbooks while ensuring formula integrity and professional formatting.

Core Features & Use Cases

  • Formula Management: Safely write, recalculate, and verify Excel formulas to ensure zero errors in financial or data models.
  • Data Processing: Efficiently handle bulk data operations between CSV, TSV, and XLSX formats using pandas and openpyxl.
  • Use Case: Use this skill to generate a multi-tab financial model from raw data, ensuring all formulas are recalculated and error-free before delivery.

Quick Start

Use the xlsx skill to open the file budget_2025.xlsx, update the revenue projections, and recalculate all formulas to ensure the final output is error-free.

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 recalculation and error validation in Python?▼

To automate Excel formula recalculation and error validation, use openpyxl to write formulas and a local LibreOffice installation to recalculate them, ensuring zero errors in your financial or data models.

Can I convert CSV and TSV files to formatted XLSX workbooks using pandas?▼

Yes, you can convert CSV and TSV files to formatted XLSX workbooks using pandas for bulk data processing and openpyxl to apply professional formatting standards to the generated Excel files.

Does this Excel automation approach require LibreOffice for formula management?▼

Yes, formula management requires a local LibreOffice installation to perform mandatory formula recalculation and error validation, guaranteeing that financial models maintain formula integrity without manual checks.

What is the best way to generate a multi-tab financial model from raw data?▼

The best way to generate a multi-tab financial model from raw data is to use openpyxl and pandas to process bulk data, write formulas, and recalculate them via LibreOffice to ensure error-free delivery.

Why do my Excel formulas show errors when generated programmatically with openpyxl?▼

Excel formulas generated programmatically with openpyxl show errors because cached values are missing, requiring a local LibreOffice installation to perform mandatory recalculation and validate formula integrity.

Related Skills

Explore More Finance & Accounting Skills→
cbbkrd-techcbbkrd-tech

xlsx

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

Community
Advanced
stevessrstevessr

xlsx

Open, clean, format, and transform spreadsheet data across XLSX, CSV, and TSV inputs.

Community
Intermediate
rakibulismrakibulism
2

xlsx

Repair and validate Excel workbooks while preserving formulas and formatting.

Community
Advanced
koolamusickoolamusic
9

xlsx

Create and edit Excel workbooks with formula validation via LibreOffice recalculation.

Community
Advanced