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

Ready to run

npx skills add https://github.com/Rheasilvia/hermes-desktop --skill xlsx-rheasilvia

💬 Prompt for ChatGPT / Claude Chat▼

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.