skills.rest
corticalstack
corticalstackCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create and update Excel workbooks with formulas, pandas analysis, and LibreOffice recalculation.

1|1|Updated Feb 2, 2026
Search Tags:#data analysis#pandas#openpyxl#xlsx#formula recalculation#spreadsheet modeling#excel error checking
One-click install
npx skills add https://github.com/corticalstack/claude-code-flow --skill xlsx-corticalstack
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/corticalstack/claude-code-flow/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/corticalstack/claude-code-flow --skill xlsx-corticalstack

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps create, edit, and analyze spreadsheet files while preventing common formula breakage and spreadsheet errors, ensuring workbooks remain recalculable and consistent over time.

Core Features & Use Cases

  • Create and edit spreadsheets safely: Build new .xlsx files or modify existing ones while preserving formulas and established formatting conventions.
  • Recalculate formulas reliably: Recompute all Excel formulas using LibreOffice and detect Excel error states like #REF!, #DIV/0!, and #VALUE!.
  • Use formulas instead of hardcoded values: Keep spreadsheets dynamic by generating Excel formulas rather than calculating results in Python.
  • Data analysis & export: Analyze spreadsheet data with pandas and write results back to Excel for further reporting and visualization.
  • Use Case: Update a financial model template by inserting new rows and extending forecast periods, then run recalculation to confirm zero formula errors and return a targeted error list if anything breaks.

Quick Start

Use the xlsx skill to modify the attached spreadsheet and guarantee there are zero Excel formula errors after recalculation.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I edit an xlsx file and preserve existing Excel formulas?▼

To preserve Excel formulas when editing an xlsx file, use a tool that generates live spreadsheet formulas instead of calculating values in Python. This keeps workbooks dynamic and recalculable after structural modifications like inserting rows or extending forecast periods.

Can I check my spreadsheet for Excel formula errors like #REF! and #DIV/0!?▼

Yes, you can check your spreadsheet for Excel formula errors like #REF! and #DIV/0! by running a recalculation engine. This process recomputes all formulas using LibreOffice and reports any detected error tokens with their exact cell locations for targeted debugging.

How do I analyze spreadsheet data with pandas and write results back to Excel?▼

To analyze spreadsheet data with pandas and write results back to Excel, use a workflow that reads the xlsx file into a DataFrame for analysis, then exports the computed results back into the workbook for further reporting and visualization while maintaining formula integrity.

Does openpyxl support recalculating Excel formulas to validate workbook consistency?▼

While openpyxl handles reading and writing xlsx files, recalculating Excel formulas to validate workbook consistency requires an external engine like LibreOffice. This combination recomputes formulas dynamically to ensure zero calculation errors and maintain spreadsheet integrity.

What is the best way to update a financial model template without breaking formulas?▼

The best way to update a financial model template without breaking formulas is to use live Excel formulas for any new calculations rather than hardcoding values. After inserting new rows or extending periods, run a full recalculation to confirm zero formula errors.

Why does my spreadsheet return #VALUE! errors after inserting new rows?▼

Your spreadsheet returns #VALUE! errors after inserting new rows because existing formulas were broken during the modification. To fix this, use a formula-preserving edit workflow that recalculates the workbook and identifies the exact cell locations of any disrupted formula references.

Related Skills

Explore More Data & Analytics Skills→
jokken79jokken79

xlsx

Automate Excel workbook creation, editing, and analysis with formulas and formatting.

Community
Advanced
SalmanferozkhanSalmanferozkhan

xlsx

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

Community
Advanced
alanharrryy-wqalanharrryy-wq
2

spreadsheet

Automate spreadsheet creation, editing, analysis, and visualization with Python.

Community
Intermediate
Gull-StackGull-Stack

xlsx

Create, edit, and analyze Excel spreadsheets with formulas using Python.

Official
Advanced