skills.rest
dev-jelly
dev-jellyCOMMUNITY
Explore all skills by this author →
𝕏@devjelly73GitHub

jelly-xlsx

Create, edit, and analyze Excel workbooks with formula integrity and formatting.

Updated Aug 27, 2026
Search Tags:#data analysis#formulas#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/dev-jelly/jelly-dotclaude --skill jelly-xlsx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: jelly-xlsx
Source: https://github.com/dev-jelly/jelly-dotclaude/tree/main/skills/jelly-xlsx
Command: npx skills add https://github.com/dev-jelly/jelly-dotclaude --skill jelly-xlsx

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

This Skill provides comprehensive spreadsheet creation, editing, and analysis, ensuring formulas remain error-free and templates are preserved.

Core Features & Use Cases

  • Zero formula errors: guarantee no #REF!, #DIV/0!, or #N/A in outputs.
  • Template preservation: match existing templates exactly when updating.
  • Data analysis: execute robust analyses with structured outputs and clear formatting.

Quick Start

Example workflows include creating a new Excel model with no hardcoded values and performing a recalculation using LibreOffice macros.

Frequently Asked Questions about jelly-xlsx

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

FAQPage Schema
How do I ensure Excel formulas don't have errors when creating or editing spreadsheets?▼

Excel formula errors like #REF!, #DIV/0!, and #N/A can break analyses. This Skill enforces zero formula errors by validating and recalculating formulas using LibreOffice, catching errors before output and ensuring data integrity across .xlsx, .xlsm, and .csv files.

Can I automate spreadsheet creation while preserving existing templates and formatting?▼

Yes. This Skill creates and edits Excel workbooks while matching existing templates exactly, maintaining color coding, number formatting, and documentation practices so updates integrate seamlessly with your current designs.

How do I perform data analysis on Excel files with reliable, structured output?▼

This Skill executes robust data analysis on Excel workbooks using pandas and openpyxl, producing structured outputs with correct formatting and clear documentation, eliminating manual recalculation and formatting errors.

What's required to run spreadsheet formulas and recalculation in an automated workflow?▼

LibreOffice is required for formula recalculation via recalc.py. The Skill uses openpyxl for file I/O and pandas for data operations, handling .xlsx, .xlsm, and .csv files end-to-end without manual spreadsheet application intervention.

Can I avoid hardcoding values when building Excel models?▼

Yes. This Skill creates Excel models with formulas and dynamic references instead of hardcoded values, ensuring calculations update automatically and remain maintainable across template revisions.

Related Skills

Explore More Data & Analytics Skills→
dobeutechdobeutech
1

xlsx

Create and edit Excel workbooks with formulas and formatting.

Community
Advanced
TIAN0517TIAN0517

xlsx

Create, edit, and analyze spreadsheets while preserving formulas across .xlsx and .xlsm formats.

Community
Advanced
el2060el2060

xlsx

Automate Excel data manipulation, analysis, and formatting with pandas and openpyxl.

Community
Advanced
Victory-HugoVictory-Hugo
1

xlsx

Create, edit, and analyze Excel workbooks with formulas using Python openpyxl and LibreOffice recalculation.

Community
Advanced