xlsx

Create and edit Excel workbooks with formulas and formatting using openpyxl.

926|107|Updated Dec 3, 2025

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

Ready to run

npx skills add https://github.com/krafton-ai/KIRA --skill xlsx-krafton-ai

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/krafton-ai/KIRA/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/krafton-ai/KIRA --skill xlsx-krafton-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Creating and maintaining complex Excel workbooks is error-prone and time-consuming, especially when formulas, formatting, and templates must be preserved across updates.

Core Features & Use Cases

Automated workbook creation and editing with formulas and formatting across .xlsx, .xlsm, and CSV workflows
Data analysis and visualization within spreadsheets while preserving existing templates and conventions
Recalculation and validation with LibreOffice via recalc.py to ensure formulas evaluate correctly and surface errors

Quick Start

Create a new or modify an existing Excel workbook with formulas and formatting, then run recalc.py to verify all calculations.

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

Automate Excel workbook creation by using openpyxl to programmatically generate and edit .xlsx files while preserving existing formulas, formatting, and templates across updates.

Can I recalculate and validate spreadsheet formulas without opening Excel?▼

Recalculate spreadsheet formulas without opening Excel by running the recalc.py script, which re-evaluates all formulas via LibreOffice, validates results, and surfaces calculation errors.

Does this spreadsheet automation approach support .xlsm and CSV formats?▼

Spreadsheet automation supports .xlsm and CSV formats, allowing you to edit files, build financial models, and perform data analysis across multiple file types within your workflows.

What is the best way to build financial models in Excel using Python?▼

Build financial models in Excel using Python by applying openpyxl for formulas and formatting alongside pandas for data analysis, ensuring templates are preserved and calculations are documented.

Why do my openpyxl formulas show as stale values instead of recalculating?▼

openpyxl formulas show stale values because the library writes formula strings without evaluating them; recalc.py addresses this by forcing LibreOffice to re-evaluate calculations and report errors.

How do I analyze spreadsheet data while keeping the original Excel template intact?▼

Analyze spreadsheet data while keeping the original Excel template intact by using pandas for data analysis and openpyxl for editing, ensuring existing conventions and formatting are preserved.