xlsx

Recalculate formulas and validate spreadsheet files for creation, cleaning, or conversion.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/hueidou/CoCo --skill xlsx-hueidou
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/hueidou/CoCo/tree/main/src/coco/agents/skills/xlsx
Command: npx skills add https://github.com/hueidou/CoCo --skill xlsx-hueidou

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, defusedxml, lxml, and includes scripts (resource) components.

What problem does it solve?

Enable reliable creation, editing, cleaning, and conversion of spreadsheet files when a spreadsheet is the primary input or deliverable, removing manual errors and ensuring models recalc correctly.

Core Features & Use Cases

  • Read, edit, and create spreadsheets: Open and modify .xlsx, .xlsm, .csv, and .tsv files while preserving templates and formatting.
  • Formula-first workflows: Insert and preserve Excel formulas (never hardcode calculated results) and use LibreOffice recalculation to populate values.
  • Validation and repair: Recalculate formulas, scan for Excel error values (#REF!, #DIV/0!, #NAME?, etc.), validate OOXML structure, and apply fixes for tracked issues.
  • Use Case: Convert messy tabular exports into a normalized workbook, add dynamic formulas, recalculate with LibreOffice, and return a validated .xlsx file ready for financial review.

Quick Start

Use the xlsx skill to recalculate formulas and validate the workbook, then return a corrected, error-free .xlsx file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I recalculate Excel formulas and fix errors in a spreadsheet programmatically?▼

To recalculate Excel formulas and fix spreadsheet errors, use a tool that applies LibreOffice-driven recalculation and scans for Excel error values like #REF! or #DIV/0!, validating the OOXML structure to produce a corrected file.

How do I convert messy CSV exports into a normalized Excel workbook with formulas?▼

Converting messy CSV exports into a normalized Excel workbook involves cleaning malformed rows, inserting dynamic formulas instead of hardcoded values, and recalcululating with LibreOffice to return a validated .xlsx file.

Does openpyxl support recalculating formulas and validating OOXML schema integrity?▼

openpyxl alone handles formula insertion and formatting, but full OOXML schema validation and formula recalculation require pairing it with LibreOffice-driven recalculation and defusedxml parsing to ensure zero formula errors.

What is the best way to preserve templates and formatting when editing .xlsx or .xlsm files?▼

The best way to preserve templates and formatting when editing .xlsx or .xlsm files is to use a formula-first workflow that modifies existing structures while applying professional font and number formatting without hardcoding calculated results.

Why does my generated xlsx file show formula errors after programmatic creation?▼

Your generated xlsx file shows formula errors because calculated results were likely hardcoded instead of recalculated; use LibreOffice-driven formula recalculation to populate values and scan for Excel error values like #NAME? or #REF!.

Can I read and edit .tsv files while ensuring zero formula errors in the output workbook?▼

Yes, you can read and edit .tsv files by normalizing the tabular data, inserting dynamic formulas, and applying OOXML schema validation to ensure the final output workbook contains zero formula errors.