xlsx

Automate spreadsheet creation, editing, and analysis for Excel-compatible workbooks.

5|3|Updated Feb 1, 2026
One-click install
npx skills add https://github.com/SebastianLHY/ruoyi-develop-claude --skill xlsx-sebastianlhy
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/SebastianLHY/ruoyi-develop-claude/tree/main/.claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/SebastianLHY/ruoyi-develop-claude --skill xlsx-sebastianlhy

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates spreadsheet creation, editing, and analysis for Excel-compatible workbooks, reducing manual data handling and error-prone tasks.

Core Features & Use Cases

  • Spreadsheet creation & editing: Build new workbooks, apply formulas, formatting, and templates while preserving existing structures.
  • Data analysis & reporting: Read, analyze, and visualize data, generate consistent outputs, and maintain audit trails.
  • Use Case: Imagine needing to generate a monthly Revenue workbook that automatically recalculates totals and preserves formulas across updates.

Quick Start

  • Run the skill against a target .xlsx file to create or modify worksheets.
  • Use the provided recalc.py script to recalculate all formulas after changes with LibreOffice.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation while preserving existing formulas and templates?

You can automate Excel spreadsheet creation by using this Skill to build new workbooks, apply formulas, and apply strict formatting while preserving existing structures and templates across updates.

What is the best way to recalculate formulas in an xlsx workbook after making automated edits?

The best way to recalculate formulas in an xlsx workbook is by running the provided recalc.py script with LibreOffice, which recalculates all formulas after changes to ensure accurate data analysis.

Can I use LibreOffice to automate data analysis and report generation for Excel-compatible files?

Yes, you can use LibreOffice alongside this Skill to automate data analysis and reporting for Excel-compatible files, enabling you to read, analyze, and visualize data while maintaining audit trails.

Does this spreadsheet automation approach support data-heavy workflows in finance and operations?

Yes, this spreadsheet automation approach explicitly supports data-heavy workflows across finance, operations, and reporting, allowing for model-building, data validation, and consistent output generation.

How do I validate data and apply strict formatting to Excel worksheets automatically?

You can validate data and apply strict formatting to Excel worksheets automatically by running this Skill against your target .xlsx file, which enforces data validation and consistent formatting rules during creation.

Why do my Excel formulas not update automatically when I generate workbooks through automation?

Excel formulas may not update automatically after automated changes because the workbook requires a dedicated recalculation step, which you can resolve by executing the included recalc.py script via LibreOffice.