skills.rest
MinhHoangDono
MinhHoangDonoCOMMUNITY
Explore all skills by this author →
GitHub

ck:xlsx

Create, edit, and validate Excel spreadsheets with formula-driven models.

Updated Mar 7, 2026
Search Tags:#financial modeling#pandas#xlsx#libreoffice#recalculate#excel formulas#spreadsheet validation
One-click install
npx skills add https://github.com/MinhHoangDono/antigravity-kit --skill ck-xlsx-minhhoangdono
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ck:xlsx
Source: https://github.com/MinhHoangDono/antigravity-kit/tree/main/.agent/skills/document-skills/xlsx
Command: npx skills add https://github.com/MinhHoangDono/antigravity-kit --skill ck-xlsx-minhhoangdono

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you create and maintain spreadsheets without broken formulas, incorrect references, or stale calculations so your Excel models stay trustworthy and updateable.

Core Features & Use Cases

  • Spreadsheet creation and editing: Build new .xlsx files or update existing ones while preserving established templates, styles, and formatting patterns.
  • Analysis and data operations: Use pandas-based analysis for tabular data handling, exports, and preparation of spreadsheet content.
  • Formula-first modeling with recalculation: Ensure calculations live in Excel formulas (not hardcoded Python values), then run LibreOffice-driven recalculation and error scanning for #REF!, #DIV/0!, #VALUE!, #NAME?, and related issues.
  • Use Case: Turn financial inputs into a dynamic model where assumptions are stored in dedicated cells, formulas reference those cells, and the workbook is recalculated and checked for any Excel formula errors before you share it.

Quick Start

Use the attached file as the target workbook and ask: "Create an updated .xlsx financial model using formulas (not hardcoded values), preserve the existing template formatting, then recalculate and return a report showing any Excel formula errors you find."

Frequently Asked Questions about ck:xlsx

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

FAQPage Schema
How do I create an Excel financial model with zero formula errors?▼

To create an Excel financial model with zero formula errors, build calculations using live Excel formulas instead of hardcoded values and run a LibreOffice recalculation to validate references and scan for issues.

How do I update an existing .xlsx file while preserving template formatting?▼

To update an existing .xlsx file while preserving template formatting, apply strict template-preserving edits that maintain established styles and formatting patterns while modifying the underlying spreadsheet content.

Can I use pandas for spreadsheet data analysis and then export to .xlsx?▼

Yes, you can use pandas for spreadsheet data analysis and export to .xlsx by performing tabular data handling, preparing content, and executing conversion workflows between .xlsx, .csv, and .tsv formats.

What is the best way to validate Excel formulas and check for broken references?▼

The best way to validate Excel formulas and check for broken references is to run a LibreOffice-driven recalculation that enforces zero Excel formula errors and safeguards against common reference and type issues.

Does LibreOffice recalculation work for converting .csv files to formatted .xlsx?▼

Yes, LibreOffice recalculation works for converting .csv files to formatted .xlsx by processing tabular data with pandas and applying formula-driven models while preserving template styles and formatting patterns.

Why do I need formula recalculation instead of just saving Python values in Excel?▼

You need formula recalculation instead of saving Python values in Excel to ensure calculations live in dynamic Excel formulas, preventing stale calculations and maintaining trustworthy, updateable spreadsheet models.

Related Skills

Explore More Data & Analytics Skills→
ChenYCLChenYCL

xlsx

Create, read, edit, and analyze Excel spreadsheet files with openpyxl and pandas.

Community
Intermediate
lazygopherslazygophers
4

office-xlsx-skills

Read, write, analyze, and convert Excel, CSV, and JSON files.

Official
Advanced
Syedyasir001Syedyasir001

xlsx

Create, edit, and recalculate Excel spreadsheets with formulas using openpyxl and LibreOffice.

Community
Advanced
JackiexiaoJackiexiao

xlsx

Create, edit, and analyze Excel files with pandas and openpyxl.

Community
Advanced