skills.rest
linxuan-sys
linxuan-sysCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Recalculate and repair Excel spreadsheet formulas with LibreOffice.

190|27|Updated Apr 22, 2026
Search Tags:#xlsx#data cleaning#formula recalculation#template preservation#error repair#spreadsheet modeling#financial assumptions
One-click install
npx skills add https://github.com/linxuan-sys/opencode-skills-chinese --skill xlsx-linxuan-sys
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/linxuan-sys/opencode-skills-chinese/tree/main/xlsx
Command: npx skills add https://github.com/linxuan-sys/opencode-skills-chinese --skill xlsx-linxuan-sys

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, LibreOffice (soffice), validators (for office pack scripts), and includes scripts (resource) components.

What problem does it solve?

This Skill helps you create, edit, repair, and convert spreadsheet files (.xlsx/.xlsm/.csv/.tsv) while preserving formatting and ensuring formulas are valid and error-free.

Core Features & Use Cases

  • Spreadsheet editing & transformation: Open and modify existing spreadsheet files, create new ones from scratch, and convert between table formats (including CSV/TSV to .xlsx).
  • Formula-first model building: Build calculations directly in Excel formulas (not hard-coded results in Python) so outputs stay dynamically updateable.
  • Recalculation and error repair workflow: Recompute all formulas using LibreOffice and detect Excel errors like #REF!, #DIV/0!, #VALUE!, and #NAME?; then iteratively repair and re-run recalculation.
  • Financial modeling guardrails: Enforce spreadsheet conventions for fonts, zero-display formatting, assumption cell placement, and consistent color coding for inputs/links/flags; ensure deliverables are spreadsheets.

Quick Start

Use the xlsx skill to repair formula errors and regenerate a clean updated spreadsheet for the attached file 'model.xlsx'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I repair Excel formula errors like #REF! and #DIV/0! in my spreadsheet model?▼

To repair Excel formula errors like #REF! and #DIV/0!, the spreadsheet is processed using LibreOffice to recompute all formulas, detect specific errors, and iteratively repair them until a clean, error-free workbook is delivered.

Can I convert CSV files to xlsx while preserving template styles and formatting?▼

Yes, you can convert CSV or TSV files to xlsx while preserving existing template styles and formatting. The process transforms table formats into Excel workbooks and maintains original visual layouts and fonts.

How do you build financial models with dynamic Excel formulas instead of hardcoded values?▼

Building financial models with dynamic Excel formulas involves writing calculations directly into the spreadsheet cells rather than computing static results in Python, ensuring outputs remain dynamically updateable for assumption changes.

Does spreadsheet recalculation require LibreOffice to validate formula errors?▼

Yes, spreadsheet recalculation requires LibreOffice (soffice) to recompute formulas and validate that Excel error cells are eliminated. This dependency ensures accurate calculation and error detection before delivery.

What are the financial modeling guardrails for spreadsheet formatting and assumption cells?▼

Financial modeling guardrails enforce spreadsheet conventions for fonts, zero-display formatting, consistent color coding for inputs and links, and proper assumption cell placement to ensure professional deliverables.

Why do my spreadsheet formulas show #NAME? errors after editing an xlsx file?▼

Spreadsheet formulas show #NAME? errors after editing due to invalid functions or syntax. The recalculation workflow detects these errors, iteratively repairs the underlying formulas, and validates the spreadsheet again.

Related Skills

Explore More Finance & Accounting Skills→
cbbkrd-techcbbkrd-tech

xlsx

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.

Community
Advanced
oimiragieooimiragieo
36

excel-generator

Generate multi-sheet Excel workbooks with formulas, charts, and formatting.

Community
Basic
jeffpeckyjeffpecky

xlsx

Automate Excel workflows with pandas and openpyxl for data analysis and editing.

Community
Advanced
EATSTEAKEATSTEAK

xlsx

Create and edit Excel spreadsheets with pandas and openpyxl.

Community
Advanced