xlsx

Create and modify Excel spreadsheets with formulas using pandas and openpyxl.

1|Updated Mar 5, 2026
One-click install
npx skills add https://github.com/smrik/ai-fund --skill xlsx-smrik
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/smrik/ai-fund/tree/main/skills/xlsx
Command: npx skills add https://github.com/smrik/ai-fund --skill xlsx-smrik

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill solves the challenge of programmatically creating, editing, and validating complex Excel spreadsheets while ensuring formula integrity and adherence to professional financial modeling standards.

Core Features & Use Cases

  • Dynamic Spreadsheet Generation: Create complex workbooks with formulas, formatting, and conditional styling using Python.
  • Automated Formula Validation: Use the integrated recalculation engine to detect and fix common errors like #REF! or #DIV/0! before delivery.
  • Financial Modeling: Apply industry-standard color coding and number formatting to ensure models are audit-ready and consistent.

Quick Start

Use the xlsx skill to load the existing financial model, update the growth rate assumptions, 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 spreadsheet creation with pandas and openpyxl?

To automate Excel spreadsheet creation, the Skill uses pandas and openpyxl to dynamically generate workbooks, construct formulas, and apply professional financial modeling formatting conventions programmatically.

Can I validate Excel formulas and fix errors like #REF! using Python?

Yes, you can validate Excel formulas and fix errors like #REF! using an integrated recalculation engine that detects and corrects common formula integrity issues before final delivery.

Does openpyxl support automated financial modeling and recalculation?

Yes, openpyxl supports automated financial modeling by creating complex workbooks with formulas, and the Skill leverages a LibreOffice-based recalculation engine to validate and recalculate all formulas.

What is the best way to apply professional formatting to financial models in Excel?

The best way to apply professional formatting to financial models is by using industry-standard color coding and number formatting conventions to ensure generated spreadsheets are audit-ready and consistent.

How do I update financial model assumptions and recalculate formulas in Excel?

You can update financial model assumptions and recalculate formulas by loading the existing workbook, modifying the growth rate parameters, and running the recalculation engine to ensure zero formula errors.