skills.rest
eastreams
eastreamsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

xlsx

Generate, edit, and validate Excel workbooks with formula error repair.

641|104|Updated Mar 5, 2026
Search Tags:#validation#finance#spreadsheet#excel#modeling#recalc
One-click install
npx skills add https://github.com/eastreams/loong --skill xlsx-eastreams
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/eastreams/loong/tree/main/skills/anthropic-office/xlsx
Command: npx skills add https://github.com/eastreams/loong --skill xlsx-eastreams

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires defusedxml, lxml, openpyxl, and includes scripts (resource) components.

What problem does it solve?

Handling spreadsheet files manually leads to formatting inconsistencies, formula errors, and time‑consuming updates, especially for financial models and data cleaning tasks.

Core Features & Use Cases

  • Professional Formatting: Enforces consistent fonts, color coding, and number formats for financial models.
  • Zero Formula Errors: Detects and repairs #REF!, #DIV/0!, #VALUE! and other Excel errors.
  • Template Preservation: Matches existing workbook templates without imposing unwanted styles.
  • Data Analysis: Uses pandas for quick data inspection, statistics, and transformation.
  • LibreOffice Recalculation: Runs scripts/recalc.py to recalculate all formulas safely.
  • Use Case: Create a new quarterly report workbook from raw CSV data, apply the company’s template, verify all formulas, and export a clean XLSX ready for stakeholders.

Quick Start

Ask the xlsx skill to generate a new workbook from "sales_data.csv" with a summary sheet and automatically recalculate all formulas.

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 formula errors like #REF! and #DIV/0! in my financial models?▼

This Skill automatically detects and repairs Excel formula errors like #REF! and #DIV/0! in your financial models, enforcing consistent formatting and ensuring zero formula errors for stakeholder-ready workbooks.

What is the best way to create an Excel workbook from a CSV file for financial reporting?▼

The best way to create an Excel workbook from CSV data is to use this Skill to generate a new file with a summary sheet, apply professional financial formatting, and export a clean XLSX ready for stakeholders.

Can I automatically recalculate all formulas in an Excel spreadsheet without opening Excel?▼

Yes, you can automatically recalculate all formulas in an Excel spreadsheet without opening Excel by running the provided LibreOffice recalculation script, which safely processes the workbook for accurate results.

How do I apply consistent professional formatting to an Excel workbook without ruining the existing template?▼

To apply consistent professional formatting without ruining an existing Excel template, this Skill matches your current workbook template and enforces professional fonts and number formats without imposing unwanted styles.

Does openpyxl support automatic LibreOffice recalculation for complex financial modeling?▼

While openpyxl handles data manipulation and formula insertion, this Skill extends its capability by running a dedicated Python script to trigger automatic LibreOffice recalculation for complex financial modeling validation.

Related Skills

Explore More Finance & Accounting Skills→
zeroix07zeroix07

xlsx

Create, edit, analyze, and convert Excel files with Python and openpyxl.

Community
Advanced
oimiragieooimiragieo
36

excel-generator

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

Community
Basic
kwoekelkwoekel

xlsx-editor

Edit Excel workbooks while preserving formulas, formatting, and multi-tab integrity.

Community
Advanced
binan-makerbinan-maker

excel-generator

Generate Excel workbooks with formulas, charts, and financial models.

Community
Advanced