skills.rest
Pans0020
Pans0020COMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Generate and edit Excel workbooks with formula-based calculations and validation.

Updated Apr 27, 2026
Search Tags:#data analysis#xlsx#template editing#error checking#recalculation#excel formulas#spreadsheet modeling
One-click install
npx skills add https://github.com/Pans0020/opencode-skills --skill xlsx-pans0020
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Pans0020/opencode-skills/tree/main/xlsx
Command: npx skills add https://github.com/Pans0020/opencode-skills --skill xlsx-pans0020

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you create, update, and analyze spreadsheet models without broken formulas, incorrect references, or stale calculations.

Core Features & Use Cases

  • Excel creation and editing: Generate or modify .xlsx/.xlsm/.csv/.tsv workbooks while preserving existing formulas and formats.
  • Formula-first modeling: Build totals, ratios, growth rates, and derived metrics using Excel formulas rather than hardcoded Python results.
  • Spreadsheet validation via recalculation: Recalculate all workbook formulas (using LibreOffice) and ensure ZERO Excel formula errors like #REF!, #DIV/0!, #VALUE!, #N/A, or #NAME?.
  • Data analysis and export: Use pandas to analyze tabular data and then write results back into Excel while keeping computations in Excel where appropriate.
  • Financial model standards: Follow finance-specific conventions for input/output coloring, number formats, assumptions placement, and documentation for hardcoded sources.

Quick Start

Use the xlsx skill to create and recalculate a spreadsheet from the provided dataset so all formulas evaluate correctly with zero Excel errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I build an Excel workbook with dynamic formulas instead of hardcoded values?▼

Generate Excel workbooks with dynamic, formula-based calculations by creating .xlsx or .xlsm models that use native Excel formulas for totals, ratios, and derived metrics rather than hardcoded Python results, preserving templates and formatting throughout the workbook.

Why does my spreadsheet show #REF! and #DIV/0! errors after editing formulas?▼

Spreadsheet formula errors like #REF!, #DIV/0!, #VALUE!, #N/A, and #NAME? occur from incorrect references or stale calculations; validate workbooks by recalculating all formulas with LibreOffice to ensure zero Excel formula errors in the final output.

Can I modify an existing .xlsx template and keep its original formatting and formulas?▼

Modify existing .xlsx and .xlsm templates while preserving original formulas and formats, applying changes to spreadsheet models without breaking existing calculations or losing template structure during the editing process.

Does LibreOffice recalculation work for validating Excel financial models?▼

LibreOffice recalculation validates Excel financial models by recalculating all workbook formulas and checking that the final output contains zero Excel formula errors, ensuring financial modeling conventions for input/output coloring and number formats are maintained.

What's the best way to analyze tabular data and write results back to Excel?▼

Analyze tabular data using pandas and write results back into Excel workbooks while keeping computations in Excel formulas where appropriate, maintaining formula-first modeling standards for derived metrics and growth rates.

How do I recalculate stale formulas in an .xlsm workbook?▼

Recalculate stale formulas in .xlsm workbooks by running a recalculation process via recalc.py with LibreOffice, validating that all formulas evaluate correctly and the final workbook contains zero Excel formula errors like #REF! and #DIV/0!.

Related Skills

Explore More Data & Analytics Skills→
wangx7wangx7

xlsx

Create and edit .xlsx, .xlsm, .csv, and .tsv files with formulas and formatting.

Community
Advanced
kerrybackkerryback

xlsx

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

Community
Advanced
ThuHuynh1438ThuHuynh1438

xlsx

Open, modify, and generate Excel workbooks using Python with openpyxl and pandas.

Community
Intermediate
anilveersingh1308anilveersingh1308

xlsx

Generate and update Excel workbooks with formula-error-free validation.

Community
Advanced