skills.rest
iani-kuli
iani-kuliCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create and edit Excel spreadsheets with pandas, openpyxl, and formula recalculation.

Updated May 5, 2026
Search Tags:#financial modeling#data analysis#pandas#openpyxl#spreadsheet#excel
One-click install
npx skills add https://github.com/iani-kuli/harness_bro --skill xlsx-iani-kuli
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/iani-kuli/harness_bro/tree/main/.claude/skills/curated/xlsx
Command: npx skills add https://github.com/iani-kuli/harness_bro --skill xlsx-iani-kuli

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill resolves the frustration of manually editing, cleaning, or fixing complex Excel files, ensuring your data models are accurate, dynamic, and error-free.

Core Features & Use Cases

  • Dynamic Modeling: Automates the creation and modification of spreadsheets using formulas instead of hardcoded values.
  • Data Integrity: Performs automated formula recalculation and error detection (e.g., #REF!, #DIV/0!) to ensure model reliability.
  • Workflow Integration: Seamlessly bridges the gap between Python-based data analysis (pandas) and Excel-based presentation (openpyxl).

Quick Start

Use the xlsx skill to load the file data.xlsx, add a new column for total revenue using an Excel formula, and then run the recalculation script to verify 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 creation instead of hardcoding values in spreadsheets?▼

Automate Excel formula creation by using openpyxl to dynamically generate formulas instead of hardcoded values. This approach ensures your financial models remain dynamic and automatically update when source data changes.

Can I use pandas and openpyxl together for spreadsheet data cleaning and presentation?▼

Yes, you can use pandas for data analysis and openpyxl for spreadsheet presentation together. This integration bridges Python-based data processing with Excel-based formatting to produce high-quality deliverables.

How do I detect and fix Excel formula errors like #REF! and #DIV/0! in my financial models?▼

Detect Excel formula errors like #REF! and #DIV/0! by running automated error verification scripts. The tool performs formula recalculation via LibreOffice integration to identify and report calculation errors for model reliability.

Does automated formula recalculation require LibreOffice integration for Excel files?▼

Automated formula recalculation for Excel files does require LibreOffice integration. This setup enforces strict formula construction rules and performs automated error verification to ensure accurate dynamic modeling outputs.

What is the best way to add a calculated revenue column to an existing Excel file using Python?▼

The best way to add a calculated revenue column is to load the Excel file with pandas, insert a new column using an openpyxl formula, and run a recalculation script to verify there are no errors.

Why do my Python-generated Excel spreadsheets show broken formulas when opened?▼

Python-generated Excel spreadsheets show broken formulas due to strict formula construction rules not being met. Enforce proper syntax during creation and run automated error verification to fix calculation issues.

Related Skills

Explore More Finance & Accounting Skills→
jeffpeckyjeffpecky

xlsx

Automate Excel workflows with pandas and openpyxl for data analysis and editing.

Community
Advanced
stefanbosakstefanbosak

xlsx

Automate Excel creation, editing, and analysis with formula-safe workflows.

Community
Advanced
Renzo-TognellaRenzo-Tognella

spreadsheet

Create, edit, analyze, and visualize spreadsheets with openpyxl and pandas.

Community
Intermediate
hgxszhj-pixelhgxszhj-pixel
2

minimax-xlsx

Open, create, edit, analyze, and validate Excel files with Python.

Community
Advanced