xlsx

Automate Excel workbook creation, editing, and analysis with formulas and formatting.

Updated Dec 4, 2025
One-click install
npx skills add https://github.com/jokken79/KobetsuV1.0 --skill xlsx-jokken79
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/jokken79/KobetsuV1.0/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/jokken79/KobetsuV1.0 --skill xlsx-jokken79

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solves?

This Skill automates complex spreadsheet creation and analysis, ensuring financial models and data reports are built with correct, dynamic formulas instead of error-prone manual calculations.

Core Features & Use Cases

  • Formula-First Creation: Builds spreadsheets using Excel formulas (like =SUM(A1:A10)) so they recalculate automatically when data changes.
  • Professional Formatting: Applies industry-standard color coding (blue for inputs, black for formulas) and number formatting.
  • Error Detection & Recalculation: Uses a built-in script to recalculate all formulas and identify errors like #REF! or #DIV/0!.
  • Use Case: You need a 5-year financial projection model. This Skill will build it with proper formulas for revenue growth and margin calculations, apply professional formatting, and verify there are zero formula errors before delivery.

Quick Start

Create a new spreadsheet that calculates the sum of values in cells A1 through A10 and puts the result in cell B1.

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 instead of hardcoded values?

Automate spreadsheet creation using Excel formulas like =SUM(A1:A10) that recalculate automatically when data changes. This Skill builds .xlsx and .xlsm files with dynamic formulas, professional formatting, and zero formula errors, ideal for financial models and data analysis workflows.

Can I build financial projection models with automatic formula recalculation?

Yes. This Skill creates multi-year financial projections using Excel formulas for revenue growth and margin calculations, applies industry-standard formatting (blue for inputs, black for formulas), and verifies all formulas are error-free before delivery.

How do I detect and fix formula errors like #REF! or #DIV/0! in spreadsheets?

Use the built-in recalculation script to identify formula errors across your workbook. This Skill enforces zero formula errors, recalculates via recalc.py and LibreOffice, and documents hardcoded references for audit compliance.

Does this work with CSV and TSV files or only Excel formats?

This Skill handles .xlsx, .xlsm, .csv, and .tsv files. It automates workbook editing and analysis across multiple formats while preserving existing templates and industry formatting conventions.

What's the best way to update spreadsheet templates while keeping formatting intact?

This Skill strictly honors existing templates and formats during updates. It applies automation to financial models and scenario planning while maintaining your template structure, color coding, and mandatory formatting rules.

Do I need programming experience to create automated financial models?

No special experience required beyond familiarity with spreadsheets. This Skill uses openpyxl and pandas to abstract formula and formatting complexity, letting you focus on financial logic rather than spreadsheet mechanics.