skills.rest
Wide-Moat
Wide-MoatOFFICIAL
Explore all skills by this author →
GitHub

xlsx

Recalculate and validate .xlsx formulas with LibreOffice and pandas.

112|26|Updated Jan 25, 2026
Search Tags:#data validation#xlsx#formula recalculation#spreadsheet modeling#pandas analysis#financial templates
One-click install
npx skills add https://github.com/Wide-Moat/open-computer-use --skill xlsx-wide-moat
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Wide-Moat/open-computer-use/tree/main/skills/public/xlsx
Command: npx skills add https://github.com/Wide-Moat/open-computer-use --skill xlsx-wide-moat

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill removes the guesswork of building, updating, and validating spreadsheets by ensuring formulas are correct and recalculated reliably instead of relying on manual checks.

Core Features & Use Cases

  • Spreadsheet creation & editing: Build new .xlsx files or modify existing ones while preserving structure, templates, and formatting conventions.
  • Formula-safe workflows: Prefer Excel formulas over hardcoded computed values so results update when inputs change.
  • Recalculation & error verification: Recalculate formulas using LibreOffice and verify the workbook for Excel error states to prevent broken models.
  • Data analysis support: Use pandas for targeted inspection and analysis of spreadsheet data after a safe preview step.
  • Use case: Update a financial model template with new assumptions, keep all existing styling and conventions, add linked calculations via formulas, then recalculate and ensure the workbook has zero formula errors.

Quick Start

Use the xlsx skill to update the attached workbook while preserving its template, then recalculate all formulas and verify there are 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 recalculate spreadsheet formulas without hardcoding computed values in an xlsx file?▼

To recalculate spreadsheet formulas safely, the xlsx skill edits .xlsx content using formula-driven logic rather than hardcoded computed values. It then applies LibreOffice-based formula recalculation to ensure outputs update dynamically when inputs change.

What is the best way to update a financial model template while preserving its existing formatting?▼

The best way to update a financial model template is by using the xlsx skill to modify existing .xlsx files while preserving structure, templates, and formatting conventions. It then recalculates all formulas and verifies the workbook has zero Excel errors.

How does pandas analysis integrate with spreadsheet modeling and validation workflows?▼

Pandas analysis integrates with spreadsheet modeling by providing targeted inspection and analysis of spreadsheet data. This occurs only after a mandatory safe spreadsheet preview step verifies the workbook's structure and formula integrity.

Can I use this to verify my workbook and prevent broken Excel error states like #REF! and #DIV/0!?▼

Yes, you can verify your workbook to prevent broken Excel error states. The xlsx skill enforces zero Excel error outcomes, specifically checking for #REF!, #DIV/0!, #VALUE!, #N/A, and #NAME? errors after formula recalculation.

Why does my spreadsheet model show #NAME? errors after modifying the xlsx file?▼

Your spreadsheet model shows #NAME? errors because formula recalculation is required after modifying the xlsx file. The xlsx skill addresses this by applying LibreOffice-based formula recalculation and enforcing zero Excel error outcomes during validation.

Do I need LibreOffice to ensure zero Excel errors when creating new spreadsheets?▼

Yes, LibreOffice-based formula recalculation is required to ensure zero Excel errors when creating new spreadsheets. The xlsx skill mandates this recalculation step plus a spreadsheet preview before completing any data analysis or modeling workflow.

Related Skills

Explore More Finance & Accounting Skills→
xu-mengnanxu-mengnan

xlsx

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv spreadsheets with formulas.

Community
Advanced
vadimcomanescuvadimcomanescu
24

xlsx

Create, edit, and analyze .xlsx spreadsheets while preserving templates and formulas.

Community
Advanced
boshi-xixixiboshi-xixixi
6

xlsx

Create and edit .xlsx, .xlsm, .csv, and .tsv spreadsheets with formulas and pandas.

Community
Advanced
pacphipacphi
14

xlsx

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

Community
Advanced