xlsx

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

Updated Mar 5, 2026
One-click install
npx skills add https://github.com/Mohamed-Elkahef/test-project --skill xlsx-mohamed-elkahef
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Mohamed-Elkahef/test-project/tree/main/.claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/Mohamed-Elkahef/test-project --skill xlsx-mohamed-elkahef

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually creating, editing, and analyzing Excel spreadsheets is time-consuming and error-prone, especially when working with complex formulas, custom formatting, and large datasets. This Skill streamlines these tasks with guided workflows and validation rules to ensure accurate, professional results.

Core Features & Use Cases

  • Formula-Driven Workflows: Automatically generate and validate Excel formulas to eliminate errors like #REF! or #DIV/0!, with support for industry-standard financial modeling conventions including color-coded inputs and assumptions.
  • Template Preservation: When modifying existing spreadsheets, exactly match the original file's formatting, style, and structural conventions to avoid breaking established workflows or business processes.
  • Use Case: A data analyst can use this Skill to process a CSV of sales data, build a formatted pivot table in Excel with calculated metrics, and recalculate all formulas to verify accuracy before sharing with stakeholders.

Quick Start

Use the xlsx skill to create a formatted monthly expense tracker spreadsheet with automatic sum formulas for each spending category.

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 and analysis with pandas?

You can automate Excel spreadsheet creation and analysis using pandas to process tabular data, openpyxl for formula and formatting operations, and LibreOffice for automated formula recalculation to ensure accurate results. This eliminates manual errors in spreadsheet workflows.

Can I modify existing spreadsheets while preserving the original formatting?

Yes, modifying existing spreadsheets while preserving original formatting conventions is supported. The Skill exactly matches the original file's formatting, style, and structural conventions to avoid breaking established workflows or business processes.

Does this approach work with CSV and TSV files or only .xlsx formats?

This approach works with .xlsx, .xlsm, .csv, and .tsv file formats. It uses openpyxl for formula and formatting operations in Excel files, and pandas for analyzing tabular data across all supported formats.

How do I validate Excel formulas to eliminate errors like #REF! or #DIV/0!?

To validate Excel formulas and eliminate errors like #REF! or #DIV/0!, the Skill automatically generates and validates formulas, then uses LibreOffice for automated formula recalculation and error scanning to detect issues.

Do I need LibreOffice installed to recalculate formulas in Excel files?

Yes, a LibreOffice installation is required for automated formula recalculation and error scanning. Additionally, openpyxl is needed for formula and formatting operations, and pandas for data analysis tasks.

What is the best way to build financial models in Excel with color-coded inputs?

The best way to build financial models in Excel is by using guided workflows that apply industry-standard conventions, including color-coded inputs and assumptions, while automatically generating and validating formulas to eliminate manual errors.