skills.rest
wanrengang
wanrengangCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create and edit Excel spreadsheets with openpyxl, pandas, and recalc.py validation.

6|3|Updated Dec 20, 2025
Search Tags:#financial modeling#data analysis#pandas#openpyxl#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/wanrengang/langchain-agent-framework --skill xlsx-wanrengang
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/wanrengang/langchain-agent-framework/tree/main/src/skills/xlsx
Command: npx skills add https://github.com/wanrengang/langchain-agent-framework --skill xlsx-wanrengang

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

Manually creating and editing spreadsheets often leads to formula errors, inconsistent formatting, and time-consuming recalculation work, especially for complex models like financial projections.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Build new .xlsx files or modify existing ones while preserving original formulas and formatting conventions.
  • Formula & Formatting Standards: Enforce industry-standard financial model color coding, number formatting, and formula construction rules to eliminate common errors like #REF! and #DIV/0!.
  • Data Analysis & Validation: Use pandas for bulk data analysis and the built-in recalc script to automatically scan all cells for formula errors and validate model integrity.
  • Use Case: For example, you can use this skill to build a multi-year revenue forecast model with linked assumption cells, proper currency formatting, and automated error checking to ensure all calculations are accurate.

Quick Start

Use the xlsx skill to create a formatted sales forecast spreadsheet with SUM and growth rate formulas from the provided monthly sales data.

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 financial model without formula errors?▼

To create an Excel financial model without formula errors, use a workflow that enforces industry-standard formula construction rules and automatically scans cells to eliminate errors like #REF! and #DIV/0!, ensuring accurate calculations.

How do I edit an existing spreadsheet without breaking formulas?▼

To edit an existing spreadsheet without breaking formulas, you must modify the file while preserving original formulas and formatting conventions using a library that supports structural cell manipulation and automated integrity validation.

Does openpyxl support validating and recalculating Excel formulas?▼

openpyxl supports reading and writing Excel formulas and custom formatting, but validating formula integrity and eliminating Excel error values requires a dedicated recalculation script to automatically scan all cells for calculation errors.

What is the best way to analyze bulk tabular data and export it to a formatted Excel file?▼

The best way to analyze bulk tabular data and export a formatted Excel file is to use pandas for the underlying data analysis and openpyxl to apply custom formatting and formulas to the generated spreadsheet output.

Can I use pandas to build a multi-year revenue forecast spreadsheet?▼

Yes, you can use pandas to process bulk tabular data for a multi-year revenue forecast, then apply openpyxl to establish linked assumption cells, proper currency formatting, and SUM formulas for the final spreadsheet model.

Related Skills

Explore More Data & Analytics Skills→
Lord1EgyptLord1Egypt
2

xlsx

Create, modify, and validate Excel spreadsheets with pandas and openpyxl.

Community
Advanced
bmadiganbmadigan
1

xlsx

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

Community
Intermediate
BaryoDevBaryoDev

xlsx

Create, edit, and analyze spreadsheet files with formulas and formatting.

Official
Advanced
billydeeii136billydeeii136

xlsx

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

Community
Advanced