xlsx

Create, edit, and analyze Excel workbooks with formulas and formatting.

2|Updated Feb 22, 2024
One-click install
npx skills add https://github.com/ddttom/allaboutv2 --skill xlsx-ddttom
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/ddttom/allaboutv2/tree/main/.claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/ddttom/allaboutv2 --skill xlsx-ddttom

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill eliminates spreadsheet errors and manual data manipulation by providing professional-grade Excel creation, editing, and analysis capabilities with automated formula verification.

Core Features & Use Cases

  • Professional Spreadsheet Creation: Build financial models with proper formatting, formulas, and industry-standard color coding.
  • Formula Verification & Error Detection: Automatically scan for and identify all Excel formula errors across all sheets.
  • Use Case: Imagine you need to create a financial projection model for a startup. Use this Skill to build a dynamic spreadsheet with revenue forecasts, expense calculations, and key metrics that automatically update when assumptions change.

Quick Start

Use the xlsx skill to create a sales forecast spreadsheet with monthly projections and growth calculations.

Frequently Asked Questions about xlsx

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create an Excel spreadsheet with formulas that automatically recalculate?

Create spreadsheets with formulas using openpyxl and pandas to build dynamic workbooks. The Skill automates formula creation, applies Excel functions for recalculation via LibreOffice, and verifies zero formula errors across all sheets, so your financial models update automatically when assumptions change.

Can I edit existing .xlsx files while preserving formulas and formatting?

Yes. Modify existing spreadsheets while preserving formulas, templates, color-coding, and number formatting standards. The Skill enforces separate assumption cells with references and documents hardcoded inputs so template conventions remain intact across edits.

How do I verify Excel formulas for errors before using a spreadsheet?

Scan workbooks for formula errors automatically across all sheets using formula verification. The Skill detects and identifies all Excel formula errors, ensuring accuracy in financial models, dashboards, and data analysis before deployment.

What file formats does this Skill support for spreadsheet analysis?

Work with .xlsx, .xlsm, .csv, and .tsv formats. The Skill handles creation, editing, and data analysis across these formats, enabling you to read, manipulate, and analyze spreadsheet data consistently regardless of source format.

Can I use this for financial modeling with professional formatting standards?

Build financial models with professional formatting, industry-standard color coding, and proper formula structure. The Skill automates creation of revenue forecasts, expense calculations, and key metrics that update dynamically while adhering to financial modeling conventions.

Does this Skill work with LibreOffice spreadsheets?

Yes. The Skill uses LibreOffice with the recalc.py script to handle Excel formulas and recalculation, supporting both Excel and LibreOffice workflows for financial models, dashboards, and general spreadsheet operations.