One-click install
npx skills add https://github.com/Estrella-231/Mathematical_modeling_tongmeng --skill xlsx-estrella-231
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Estrella-231/Mathematical_modeling_tongmeng/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/Estrella-231/Mathematical_modeling_tongmeng --skill xlsx-estrella-231

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires validators, and includes scripts (resource) components.

What problem does it solve?

This Skill removes the friction of working with spreadsheet files by helping you open, clean, restructure, and update tabular data while ensuring the spreadsheet outputs are calculation-safe and error-free.

Core Features & Use Cases

  • Spreadsheet creation and transformation: Build new Excel workbooks, convert between tabular formats (xlsx/xlsm/csv/tsv), and restructure messy tables into valid spreadsheet layouts.
  • Safe editing of existing files: Add/rename columns, clean malformed rows, repair headers, and update formulas without breaking references.
  • Formula integrity and validation: Ensure every Excel model is produced with ZERO Excel errors and supports formula recalculation via LibreOffice when formulas are present.

Quick Start

Ask to "clean and restructure the attached xlsx file, fix any formula issues, and produce a new error-free spreadsheet as output.xlsx".

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I fix common Excel errors like #REF! and #DIV/0! in my spreadsheet?

To fix Excel errors like #REF! and #DIV/0!, you need to repair spreadsheet formulas and validate references. This ensures calculation-safe outputs by enforcing LibreOffice-based recalculation and preventing common formula issues in your xlsx files.

What is the best way to clean and restructure messy CSV data into a valid Excel workbook?

The best way to clean CSV data into an Excel workbook is to perform tabular conversion and restructure malformed rows into valid spreadsheet layouts. This process repairs headers and updates formulas without breaking existing references.

How do I update formulas in an existing xlsx file without breaking references?

To update formulas in an existing xlsx file without breaking references, apply safe editing techniques that add or rename columns while enforcing formula integrity. This produces calculation-safe deliverables with zero Excel errors.

Does LibreOffice support formula recalculation for spreadsheet validation?

Yes, LibreOffice supports formula recalculation for spreadsheet validation. It enforces reliable calculation checks on existing xlsx and xlsm workbooks, ensuring that formula outputs are completely error-free and validation-ready.

Can I convert TSV files to xlsx while fixing formula issues?

Yes, you can convert TSV files to xlsx while fixing formula issues through tabular conversion. This process cleans malformed rows, repairs headers, and outputs a calculation-safe spreadsheet file with zero Excel errors.

Why does my spreadsheet show #NAME? errors after editing columns?

Your spreadsheet shows #NAME? errors after editing columns because broken formula references occur during structural updates. Repairing the spreadsheet with enforced formula recalculation prevents these errors and restores calculation-safe outputs.