xlsx

Create, edit, and analyze spreadsheets while preserving formulas and templates.

Updated Nov 4, 2025

Search Tags:#automation #formulas #spreadsheet #excel #data-analysis #xlsx

Ready to run

npx skills add https://github.com/Ryno-Crypto-Mining-Services/ryno-assets --skill xlsx-ryno-crypto-mining-services

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Ryno-Crypto-Mining-Services/ryno-assets/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/Ryno-Crypto-Mining-Services/ryno-assets --skill xlsx-ryno-crypto-mining-services

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

This Skill automates spreadsheet creation, editing, and analysis, handling formulas, formatting, data analysis, and visualization to save time and reduce errors.

Core Features & Use Cases

Create new spreadsheets with formulas and formatting
Read and analyze data from spreadsheets (xlsx, xlsm, CSV, TSV)
Modify existing spreadsheets while preserving existing formulas
Data analysis and visualization within spreadsheets
Recalculate formulas to ensure up-to-date outputs
Use Case: Build a budgeting model that auto-updates as inputs change

Quick Start

Run the Excel formula recalculation on a sample workbook, e.g.: python .claude/skills/xlsx/recalc.py budget.xlsx

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 with formulas and formatting?▼

Automate Excel spreadsheet creation by using openpyxl to build workbooks with formulas, apply formatting rules, and preserve template structure. This Skill handles formula integrity and color coding conventions to eliminate manual errors across .xlsx, .xlsm, and CSV files.

Can I modify existing Excel templates without breaking formulas?▼

Yes. This Skill modifies existing spreadsheets while preserving formulas and template integrity. It maintains all formula logic and formatting conventions, allowing safe edits to data without recalculation errors or structural damage.

How do I recalculate formulas in Excel files to ensure outputs are current?▼

Run formula recalculation using recalc.py with LibreOffice integration to update all formula outputs in .xlsx and .xlsm files. This ensures spreadsheet outputs reflect the latest input data and formula dependencies.

What's the best way to read and analyze data from multiple spreadsheet formats?▼

Read and analyze spreadsheet data across .xlsx, .xlsm, CSV, and TSV formats using pandas integration for data processing. This Skill handles format compatibility and data extraction while maintaining number formatting and structure integrity.

Can I build dynamic spreadsheets that auto-update when inputs change?▼

Yes. Create dynamic spreadsheets with formulas that auto-recalculate as inputs change. Use this Skill to design budgeting models, financial templates, or any workbook where dependent calculations must update automatically.

Do I need additional tools beyond openpyxl for formula recalculation and data analysis?▼

This Skill integrates openpyxl for formulas and formatting, pandas for data analysis, and recalc.py with LibreOffice for formula recalculation. These dependencies together handle zero-error formula maintenance, data transformation, and spreadsheet visualization.