skills.rest
georgekhananaev
georgekhananaevCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create, edit, and analyze Excel workbooks in XLSX, XLSM, and CSV formats.

27|9|Updated Jan 4, 2026
Search Tags:#automation#formulas#spreadsheet#excel#xlsx#recalc
One-click install
npx skills add https://github.com/georgekhananaev/claude-skills-vault --skill xlsx-georgekhananaev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/georgekhananaev/claude-skills-vault/tree/main/.claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/georgekhananaev/claude-skills-vault --skill xlsx-georgekhananaev

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill automates the tedious tasks of creating, editing, and analyzing spreadsheets, ensuring formulas are preserved and results are consistently recalculated across workbooks.

Core Features & Use Cases

  • Create new Excel workbooks with formulas and formatting across .xlsx, .xlsm, and related formats.
  • Read, transform, and analyze data using Python tools like pandas and openpyxl.
  • Recalculate formulas and validate results using recalc.py with LibreOffice integration for accurate, repeatable results.
  • Preserve existing templates and formatting when updating workbooks to maintain consistency.

Quick Start

Create a new workbook with a simple sum formula in B2 using openpyxl, then run recalc.py to verify formulas in the file.

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 and editing with Python?▼

To automate Excel workbook creation and editing, this skill uses openpyxl and pandas to generate, read, and transform data across .xlsx, .xlsm, and .csv formats while preserving existing templates and formatting.

How do I recalculate Excel formulas automatically without opening the file?▼

To recalculate Excel formulas automatically, this skill integrates a recalc.py script with LibreOffice to process and validate formula results, ensuring accurate and repeatable outputs across workbooks.

Can I read and transform data across xlsx, xlsm, and csv files in one workflow?▼

Yes, you can read and transform data across xlsx, xlsm, and csv files in a single workflow by leveraging pandas and openpyxl for comprehensive data analysis and modeling.

What is the best way to preserve existing Excel templates and formatting when updating spreadsheets?▼

The best way to preserve existing Excel templates and formatting when updating spreadsheets is to use openpyxl, which maintains template consistency while applying new data and formulas.

Do I need LibreOffice to validate and recalculate formulas in Excel workbooks?▼

Yes, you need LibreOffice integrated with the recalc.py script to accurately validate and recalculate formulas within Excel workbooks for consistent reporting and data-cleaning results.

Why are my Excel formulas not recalculating when I edit spreadsheets programmatically?▼

Excel formulas may not recalculate when editing programmatically because Python libraries alone do not evaluate formulas; this skill solves the limitation by running recalc.py with LibreOffice to force recalculation.

Related Skills

Explore More Data & Analytics Skills→
caoronglincaoronglin
2

xlsx

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

Community
Advanced
zinohomezinohome

xlsx

Create and validate XLSX workbooks with automated formula recalculation and error checking.

Community
Advanced
cgm-freecgm-free

xlsx

Automates spreadsheet editing and cleaning for .xlsx, .xlsm, .csv, .tsv using pandas and openpyxl with LibreOffice recalculation.

Community
Advanced
hmzainjamilhmzainjamil
1

excel-automation

Automate live Excel workbooks, dashboards, and reports with xlwings.

Community
Advanced