skills.rest
icyzh
icyzhCOMMUNITY
Explore all skills by this author →
Website𝕏@icyzhbeGitHub

xlsx

Create, read, and edit Excel spreadsheets with formulas and formatting.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill eliminates the risk of manual spreadsheet errors and the tedious nature of formula management by providing a robust, automated environment for creating, editing, and verifying Excel workbooks.

Core Features & Use Cases

  • Automated Formula Recalculation: Ensures every formula-bearing output is error-free and recalculated using LibreOffice before delivery.
  • Data Manipulation: Seamlessly handles bulk data operations, formatting, and complex spreadsheet structures using pandas and openpyxl.
  • Use Case: Use this skill to generate a complex financial model with multiple tabs and cross-sheet references, ensuring all formulas are valid and the output is professionally formatted.

Quick Start

Use the xlsx skill to open the file budget.xlsx, update the revenue projections in the assumptions tab, and recalculate all formulas to ensure the final totals are correct.

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 for financial modeling?▼

Automate Excel formula recalculation by using openpyxl and pandas to manage spreadsheet structures, then leveraging LibreOffice to validate and recalculate complex formulas, ensuring error-free financial modeling output.

What's the best way to clean and convert tabular data in Excel spreadsheets?▼

Clean and convert tabular data in Excel spreadsheets by utilizing pandas for bulk data manipulation and openpyxl for formatting, seamlessly handling complex spreadsheet structures to produce validated outputs.

Do I need LibreOffice to validate cross-sheet formulas in Excel workbooks?▼

Yes, LibreOffice is required to recalculate and validate cross-sheet formulas in Excel workbooks, ensuring every formula-bearing output is verified and error-free before final delivery.

Can I update revenue projections in an assumptions tab and recalculate all Excel formulas automatically?▼

Yes, you can update revenue projections in an assumptions tab and automatically recalculate all Excel formulas using openpyxl for data entry and LibreOffice for formula validation to ensure correct totals.

Does openpyxl support complex financial models with multiple tabs and cross-sheet references?▼

Yes, openpyxl supports complex financial models with multiple tabs and cross-sheet references, allowing you to create, edit, and format Excel workbooks while ensuring formulas are valid through LibreOffice recalculation.

Why does my Excel spreadsheet output contain formula errors after editing with pandas?▼

Excel spreadsheet formula errors after editing with pandas occur because formulas are not automatically recalculated; you need LibreOffice to validate and recalculate formula-bearing outputs for error-free delivery.

Related Skills

Explore More Finance & Accounting Skills→
Lord1EgyptLord1Egypt
2

xlsx

Create, modify, and validate Excel spreadsheets with pandas and openpyxl.

Community
Advanced
States-MediaStates-Media

Excel Analysis

Analyze Excel spreadsheets with pandas and openpyxl for reports and charts.

Official
Intermediate
RehanTharushaRehanTharusha
1

xlsx

Create, edit, and analyze Excel files with openpyxl and pandas.

Community
Advanced
langbyyilangbyyi
96

xlsx

Create, edit, analyze, and validate Excel spreadsheet files with pandas and openpyxl.

Community
Advanced