xlsx

Create and edit Excel workbooks with formulas and formatting.

Updated Oct 21, 2025
One-click install
npx skills add https://github.com/LinSoap/Saulgooo --skill xlsx-linsoap
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/LinSoap/Saulgooo/tree/main/resources/skills/xlsx
Command: npx skills add https://github.com/LinSoap/Saulgooo --skill xlsx-linsoap

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates repetitive and complex spreadsheet tasks, from creating new files with dynamic formulas to analyzing existing data and ensuring formula integrity. It eliminates manual errors and saves significant time in data manipulation and reporting.

Core Features & Use Cases

  • Dynamic Spreadsheet Creation: Generate new .xlsx files with complex formulas, precise formatting, and adherence to financial modeling standards.
  • Data Analysis & Editing: Read, analyze, and modify existing spreadsheets using powerful tools like pandas, while preserving original formulas and formatting.
  • Automated Formula Recalculation & Validation: Recalculate all formulas in a workbook and automatically detect and report common Excel errors (e.g., #REF!, #DIV/0!).
  • Use Case: You need to create a monthly financial report that aggregates data, applies growth rates, and calculates projections. This Skill can automatically generate the entire spreadsheet, including all formulas, color-coded assumptions, and validate it for errors, reducing manual effort from hours to minutes.

Quick Start

Create a new Excel file named 'quarterly_sales.xlsx' with columns for 'Month', 'Revenue', and 'Expenses', and a formula for 'Profit'.

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 formulas and formatting?

Automate Excel spreadsheet creation by using openpyxl to generate .xlsx files with dynamic formulas, precise formatting, and financial modeling standards. The Skill handles formula writing, color-coded assumptions, and numeric formatting automatically, reducing manual effort from hours to minutes.

Can I read and modify existing Excel files while preserving formulas?

Yes, you can read and analyze existing spreadsheets using pandas integration while preserving original formulas and formatting. The Skill modifies data without disrupting formula integrity or template conventions.

How do I detect and fix formula errors in Excel workbooks?

Recalculate all formulas in a workbook and automatically detect common Excel errors like #REF! and #DIV/0!. The Skill validates formulas through a LibreOffice-based recalc workflow and reports errors for correction.

What's the best way to create financial reports with data aggregation and projections?

Generate monthly or quarterly financial reports automatically with data aggregation, growth rate application, and projection formulas. The Skill creates complete spreadsheets with validated formulas and industry-standard formatting in one operation.

Does this work for updating existing financial templates?

Yes, the Skill updates existing templates while enforcing zero formula errors and preserving template conventions. It maintains spreadsheet structure and formula logic while modifying data values.

What file formats and tools does this support?

.xlsx format with openpyxl and pandas integration. The Skill relies on Excel formulas with LibreOffice-based recalculation to ensure compatibility and accuracy across financial modeling workflows.