skills.rest
igorferreira
igorferreiraCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create and edit Excel workbooks with formulas and formatting.

Updated Oct 23, 2025
Search Tags:#automation#financial modeling#reporting#data analysis#spreadsheet#excel#error checking
One-click install
npx skills add https://github.com/igorferreira/gestao-projetos-exemplo --skill xlsx-igorferreira
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/igorferreira/gestao-projetos-exemplo/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/igorferreira/gestao-projetos-exemplo --skill xlsx-igorferreira

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas.

What problem does it solve?

Manual spreadsheet tasks are time-consuming, repetitive, and prone to errors. This Skill eliminates the drudgery by automating complex Excel operations, from dynamic formula creation and data entry to advanced analysis and error checking, ensuring accuracy and freeing up your valuable time.

Core Features & Use Cases

  • Dynamic Spreadsheet Creation: Generate new .xlsx files with intricate formulas, custom formatting, and robust data validation.
  • Intelligent Data Analysis: Read, analyze, and modify existing spreadsheets while preserving complex formulas, styles, and structural integrity.
  • Error-Free Recalculation: Automatically recalculate all formulas and identify/fix common Excel errors (e.g., #REF!, #DIV/0!) to guarantee data integrity.
  • Use Case: Quickly create a comprehensive financial report by pulling raw data, applying complex financial models with industry-standard color coding, and automatically verifying all calculations, without ever manually touching Excel.

Quick Start

Example: Create a new Excel file with a sum formula and recalculate

from openpyxl import Workbook wb = Workbook() sheet = wb.active sheet['A1'] = 10 sheet['A2'] = 20 sheet['A3'] = '=SUM(A1:A2)' wb.save('my_data.xlsx')

MANDATORY: Recalculate formulas to get values and check for errors

python .claude/skills/xlsx/recalc.py my_data.xlsx

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 spreadsheet creation by using openpyxl to generate .xlsx files with dynamic formulas, custom formatting, and data validation. The Skill handles formula creation, applies formatting conventions, and recalculates all formulas to ensure accuracy without manual Excel interaction.

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

Yes. The Skill reads and analyzes existing .xlsx, .xlsm, .csv, and .tsv files while preserving complex formulas, styles, and structural integrity. It updates workbooks intelligently, maintaining templates and color-coding conventions throughout edits.

What's the best way to check for and fix Excel formula errors automatically?▼

The Skill enforces zero formula errors by automatically recalculating all formulas and identifying common Excel errors like #REF! and #DIV/0!. LibreOffice-based recalculation verifies data integrity and flags errors for correction before final output.

How do I perform data analysis on spreadsheet data using Python?▼

Use pandas integration to read, analyze, and manipulate spreadsheet data directly. The Skill combines openpyxl for Excel operations with pandas workflows, enabling advanced data analysis while maintaining Excel formula precision and structure.

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

The Skill handles .xlsx, .xlsm, .csv, and .tsv files seamlessly. It automates creation and analysis across all four formats, applying consistent data validation, formatting, and error checking regardless of file type.

When should I use Excel formulas instead of hardcoding values in Python?▼

Use Excel formulas for dynamic calculations to preserve recalculation capability and auditability. The Skill documents any hardcoded values with source notes and relies on formulas for financial models and reports to ensure accuracy and maintainability.

Related Skills

Explore More Finance & Accounting Skills→
jesseotremblayjesseotremblay
1

processing-data

Transform, clean, and extract structured information from CSV and JSON data.

Community
Basic
hoanghn61hoanghn61

report_exporter

Converts TechStackReport JSON into Markdown, HTML, and PDF exports.

Community
Intermediate
kmshihab7878kmshihab7878
6

data-analysis

Convert natural language analytics requests into pandas and SQL queries.

Community
Intermediate
vasilyu1983vasilyu1983
73

document-xlsx

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

Community
Advanced