xlsx

Name: xlsx
Availability: InStock
Author: ygfuyfffdf-max

Create and edit Excel workbooks with formulas using openpyxl and LibreOffice recalc.

Updated Jan 29, 2026

Search Tags:#automation #Excel #openpyxl #formulas #data-analysis #xlsx #recalc

Ready to run

npx skills add https://github.com/ygfuyfffdf-max/v0-crypto-dashboard-design --skill xlsx-ygfuyfffdf-max

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/ygfuyfffdf-max/v0-crypto-dashboard-design/tree/main/.claude/skills/xlsx-processing-en-anthropic
Command: npx skills add https://github.com/ygfuyfffdf-max/v0-crypto-dashboard-design --skill xlsx-ygfuyfffdf-max

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) components.

What problem does it solve?

This Skill automates the creation, editing, and analysis of Excel workbooks, helping teams avoid manual spreadsheet tasks and errors.

Core Features & Use Cases

Automated workbook creation: Generate new Excel files with formulas and custom formatting.
Template preservation & modification: Update existing spreadsheets while preserving formulas and templates.
Data analysis & recalculation: Read data, perform analyses, and refresh formulas reliably using a LibreOffice-based recalc script.

Quick Start

Create a new workbook named budget.xlsx with a simple formula (e.g., =SUM(B2:B10)) and run the recalc script to refresh 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 workbook creation with formulas using Python?▼

To automate Excel workbook creation, generate new xlsx files with formulas using openpyxl, then run a LibreOffice-based recalc script to refresh formulas and produce reproducible recalculations.

Can I update existing Excel templates while preserving formulas?▼

Yes, you can update existing Excel templates while preserving formulas. The Skill modifies spreadsheet data without breaking the original template structure, formatting, or hardcoded values.

How does openpyxl handle Excel formula recalculation?▼

openpyxl handles Excel formula recalculation by integrating a LibreOffice-based recalc script. This approach refreshes formulas reliably while preserving formatting and documenting hardcoded values for accurate data analysis.

What is the best way to read and analyze data from an xlsx file in Python?▼

The best way to read and analyze data from an xlsx file is using openpyxl for workbook manipulation. It extracts data for analysis and updates existing spreadsheets while enabling reproducible recalculations.

Do I need LibreOffice to refresh Excel formulas in openpyxl?▼

Yes, a LibreOffice-based recalc script is required to refresh Excel formulas. openpyxl alone cannot evaluate formulas, so this script ensures reliable recalculations while preserving spreadsheet formatting.

Are there limitations when automating Excel data analysis with openpyxl?▼

A limitation of automating Excel data analysis with openpyxl is its inability to natively evaluate formulas. This requires a LibreOffice-based recalc script to refresh formulas and document hardcoded values accurately.