xlsx

Create, read, and edit Excel workbooks and CSV files with formulas.

Updated Jun 17, 2026
One-click install
npx skills add https://github.com/cxnaive/hermes-agent-llbot --skill xlsx-cxnaive
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/cxnaive/hermes-agent-llbot/tree/main/skills/productivity/xlsx
Command: npx skills add https://github.com/cxnaive/hermes-agent-llbot --skill xlsx-cxnaive

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, ensuring that formulas are accurate and data is correctly formatted without manual spreadsheet manipulation.

Core Features & Use Cases

  • Formula Management: Automates the insertion of complex Excel formulas while ensuring they are recalculated and error-free.
  • Data Processing: Efficiently handles bulk data operations between Python data structures and Excel files using pandas and openpyxl.
  • Use Case: Use this skill to generate a multi-tab financial model from raw data, ensuring all cross-sheet references are intact and all formulas are validated via LibreOffice recalculation.

Quick Start

Use the xlsx skill to open the file budget_2025.xlsx, update the revenue projections using the provided data, and recalculate all formulas to ensure there are no errors.

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 insertion and ensure zero-error recalculation?

Automating Excel formula insertion requires inserting complex formulas programmatically and validating them via LibreOffice recalculation to ensure zero errors. This approach guarantees cross-sheet references remain intact and calculations execute accurately without manual spreadsheet manipulation.

Can I use pandas and openpyxl to generate a multi-tab financial model from raw data?

Using pandas and openpyxl supports generating a multi-tab financial model from raw data by handling bulk data operations between Python data structures and Excel files. This enables efficient data processing while maintaining correct formatting and intact cross-sheet references.

What's the best way to convert tabular data and apply professional font styling to spreadsheets?

Converting tabular data and applying professional font styling to spreadsheets is achieved through programmatic workbook editing with openpyxl. This process ensures precise adherence to user-defined spreadsheet structures while applying consistent professional formatting across all cells.

Does openpyxl support cross-sheet references when editing complex Excel workbooks?

Openpyxl supports cross-sheet references when editing complex Excel workbooks, allowing formulas to reference data across multiple tabs. Combined with LibreOffice recalculation, it validates that all formula-based calculations and cross-sheet dependencies remain intact and error-free.

Why does Excel formula recalculation fail when updating revenue projections in budget workbooks?

Excel formula recalculation fails when updating revenue projections if formulas are not properly recalculated after data insertion. Validating formulas via LibreOffice recalculation ensures all updated revenue projections and dependent calculations execute without errors across the workbook.