xlsx

Create, edit, and analyze Excel-compatible spreadsheets with formulas.

Updated Dec 4, 2025

Search Tags:#automation #Excel #formulas #spreadsheet #data-analysis #LibreOffice #recalculation

Ready to run

npx skills add https://github.com/jr2804/prompts --skill xlsx-jr2804

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/jr2804/prompts/tree/main/skills/documents/xlsx
Command: npx skills add https://github.com/jr2804/prompts --skill xlsx-jr2804

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates spreadsheet creation, editing, and analysis to eliminate tedious manual workbook work.

Core Features & Use Cases

Create new spreadsheets with formulas and formatting to support dynamic data workflows.
Read, analyze, and visualize data while preserving existing formulas during updates.
Recalculate formulas across Excel-compatible formats (.xlsx, .xlsm, .csv, .tsv) to ensure outputs stay current.

Quick Start

Use the xlsx skill to generate a basic workbook with a monthly sales table and inline formulas.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I automate Excel formula creation and recalculation in xlsx files?▼

You can automate Excel formula creation and recalculation by using openpyxl and pandas to generate workbooks, then running the recalc.py script with LibreOffice to ensure formulas stay accurate and current.

Can I update spreadsheet data without overwriting existing Excel formulas?▼

Yes, you can update spreadsheet data without overwriting existing Excel formulas; the skill reads and edits workbooks while specifically preserving existing formulas during any data updates or modifications.

What spreadsheet formats are supported for automated data analysis and visualization?▼

Supported spreadsheet formats for automated data analysis and visualization include Excel-compatible files like .xlsx, .xlsm, .csv, and .tsv, allowing you to read, analyze, and visualize data seamlessly.

Do I need LibreOffice to recalculate formulas across Excel-compatible files?▼

Yes, you need LibreOffice to recalculate formulas across Excel-compatible files because the skill uses the recalc.py script alongside LibreOffice to process and update formula outputs accurately.

What is the best way to build a dynamic workbook with inline formulas from scratch?▼

The best way to build a dynamic workbook with inline formulas from scratch is to automate spreadsheet creation using Python-based Excel I/O libraries like openpyxl and pandas to apply formulas and formatting.

Are there limitations when using Python libraries to edit and analyze Excel files?▼

Limitations when using Python libraries like openpyxl and pandas to edit Excel files include potential formula evaluation gaps, which is why LibreOffice recalculation is required to guarantee accurate formula outputs.