skills.rest
ygfuyfffdf-max
ygfuyfffdf-maxCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

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
One-click install
npx skills add https://github.com/ygfuyfffdf-max/v0-crypto-dashboard-design --skill xlsx-ygfuyfffdf-max
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
zhuxiningzhuxining

xlsx

Create, edit, and analyze .xlsx, .xlsm, and .csv spreadsheets with openpyxl.

Community
Advanced
TouricksTouricks
4

xlsx

Create, edit, and analyze spreadsheets across xlsx, xlsm, csv, and tsv formats.

Community
Advanced
trungdo9trungdo9
3

xlsx

Create, edit, and analyze .xlsx files with Python and openpyxl.

Community
Advanced
duy-tungduy-tung

ck:xlsx

Create, edit, and analyze .xlsx files with pandas and openpyxl.

Community
Advanced