xlsx

Create, edit, and convert spreadsheet workbooks with dynamic formulas.

1|Updated May 17, 2026
One-click install
npx skills add https://github.com/mykcs/myk-skills --skill xlsx-mykcs
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/mykcs/myk-skills/tree/main/xlsx
Command: npx skills add https://github.com/mykcs/myk-skills --skill xlsx-mykcs

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, LibreOffice, gcc, timeout, and includes scripts (resource) components.

What problem does it solve?

This Skill helps you create, edit, and analyze spreadsheet files (.xlsx/.csv/.tsv) while keeping models reliable—especially by preventing formula errors and preserving existing templates and conventions.

Core Features & Use Cases

  • Create and edit spreadsheets with formulas preserved: Use pandas/openpyxl workflows to add data, update cells, and build dynamic models without hardcoding computed values.
  • Recalculate formulas reliably: Forces a full formula recalculation using a LibreOffice-backed script and detects Excel error tokens like #REF!, #DIV/0!, and #VALUE!.
  • Spreadsheet safety guardrails: Enforces strong requirements such as “zero formula errors”, preservation of existing formatting conventions when modifying templates, and structured guidance for financial-model cell styling.

Quick Start

Use the xlsx skill to modify the attached spreadsheet 'model.xlsx' and ensure all formulas recalculate with 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 edit and recalculate xlsx financial models without hardcoding formula values?

To edit and recalculate xlsx financial models without hardcoding values, use a workflow that adds data via pandas and openpyxl while preserving dynamic formulas, then forces a full LibreOffice-backed recalculation. This guarantees computed values remain dynamic and formula-safe across updates.

How do I check an Excel workbook for formula errors like #REF! or #DIV/0!?

To check an Excel workbook for formula errors like #REF! or #DIV/0!, run a LibreOffice-driven recalculation script that scans the spreadsheet and detects Excel error tokens. This validates the workbook to guarantee zero Excel error tokens after editing.

Can I update spreadsheet templates and preserve existing formatting conventions?

Yes, you can update spreadsheet templates and preserve existing formatting conventions. The process enforces strong requirements to maintain existing template styles and structured guidance for financial-model cell styling when modifying .xlsx files.

Does openpyxl support full formula recalculation for spreadsheet automation?

While openpyxl handles cell updates and data manipulation, full formula recalculation requires a LibreOffice-backed script. The workflow combines openpyxl for editing with LibreOffice to force formula recalculation and guarantee zero Excel error tokens.

What is the best way to build financial models from CSV and TSV inputs?

The best way to build financial models from CSV and TSV inputs is using a pandas and openpyxl workflow that converts the data into .xlsx workbooks, adds dynamic formulas without hardcoding values, and runs error scanning to ensure reliable spreadsheet automation.

Why do my spreadsheet formulas break when converting or editing xlsx files?

Spreadsheet formulas break when converting or editing xlsx files if computed values are hardcoded or template conventions are lost. Using a formula-safe workflow that forces LibreOffice recalculation and scans for error tokens prevents this issue.