skills.rest
michellepellon
michellepellonCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create and validate Excel spreadsheets with formulas and formatting.

Updated Jan 14, 2024
Search Tags:#financial modeling#reporting#data analysis#Excel#formulas#XLSX#spreadsheet automation
One-click install
npx skills add https://github.com/michellepellon/dotfiles --skill xlsx-michellepellon
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/michellepellon/dotfiles/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/michellepellon/dotfiles --skill xlsx-michellepellon

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill automates complex Excel spreadsheet tasks, from data analysis and report generation to creating financial models with strict formatting and formula validation. It eliminates manual data entry, formula errors, and inconsistent formatting, ensuring high-quality, reliable, and standardized Excel outputs.

Core Features & Use Cases

  • Comprehensive Spreadsheet Management: Read, create, edit, and analyze .xlsx files with full support for data, formulas, and advanced formatting.
  • Financial Model Standards: Apply industry-standard color coding (blue for inputs, black for formulas) and number formatting for clarity and consistency.
  • Automated Formula Recalculation & Validation: Critically, it uses LibreOffice to recalculate all formulas and report any errors, guaranteeing accuracy before delivery.
  • Use Case: You need to build a quarterly financial projection model. This skill can generate the Excel file, populate it with initial data, add complex formulas for revenue and expense projections, apply standard financial color coding, and then automatically validate all formulas to ensure there are no errors before you present it.

Quick Start

Reading Data with pandas

import pandas as pd df = pd.read_excel('data.xlsx') print(df.head())

Creating Excel Files with openpyxl

from scripts.xlsx_operations import ( create_workbook, add_formula, set_cell_color ) wb = create_workbook('output.xlsx') ws = wb.active ws['A1'] = 'Revenue' ws['B1'] = 100000 add_formula(ws, 'B2', '=B1*1.1') set_cell_color(ws, 'B1', 'blue') set_cell_color(ws, 'B2', 'black') wb.save('output.xlsx')

Formula Recalculation (CRITICAL)

python scripts/recalc.py output.xlsx