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.