skills.rest
Ryno-Crypto-Mining-Services
Ryno-Crypto-Mining-ServicesOFFICIAL
Explore all skills by this author →
Website𝕏@RynoMiningGitHub

xlsx

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

Updated Nov 4, 2025
Search Tags:#automation#formulas#spreadsheet#excel#data-analysis#xlsx
One-click install
npx skills add https://github.com/Ryno-Crypto-Mining-Services/ryno-assets --skill xlsx-ryno-crypto-mining-services
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
byteowlzbyteowlz
57

xlsx

Create and edit Excel spreadsheets with formulas and data analysis.

Official
Advanced
MoshPitCodesMoshPitCodes
1

xlsx

Generate, edit, and analyze Excel workbooks with OpenPyXL and LibreOffice.

Community
Intermediate
SoftSystemsStudioSoftSystemsStudio

xlsx

Create, edit, and validate Excel workbooks with formulas using openpyxl.

Community
Advanced
shuakyle21shuakyle21
5

xlsx

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

Community
Intermediate