xlsx

Name: xlsx
Availability: InStock
Author: codingheader

Create and edit Excel workbooks with formulas and formatting.

Updated Jan 28, 2026

Search Tags:#python #pandas #openpyxl #excel #data-analysis #xlsx #formula

Ready to run

npx skills add https://github.com/CodingHeader/MySkills --skill xlsx-codingheader

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/CodingHeader/MySkills/tree/main/skills/xlsx
Command: npx skills add https://github.com/CodingHeader/MySkills --skill xlsx-codingheader

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Excel files often require repetitive formatting, complex formulas, and consistent data analysis workflows. This Skill provides a structured approach to build, modify, and review spreadsheets (.xlsx, .xlsm, .csv, .tsv) with formula integrity and standardized visuals.

Core Features & Use Cases

Create and edit Excel workbooks with support for formulas and formatting
Read, analyze, and summarize data using Python tools (pandas, openpyxl)
Preserve existing templates and formulas when updating files
Recalculate formulas on demand using the recalc.py script via LibreOffice
Multi-sheet workbooks and data visualization

Quick Start

Create or load an Excel workbook, modify data and formulas, then run recalc.py to recalculate all 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 file creation and editing with formulas using Python?▼

You can automate Excel file creation and editing by using Python tools like pandas and openpyxl to write data, apply formulas, and format spreadsheets across .xlsx, .xlsm, .csv, and .tsv files.

How do I recalculate Excel formulas on demand outside of the Excel application?▼

Excel formulas can be recalculated on demand by running the recalc.py script, which uses a LibreOffice-based workflow to process and update formula values in .xlsx files.

Can I update Excel data while preserving existing templates and formulas?▼

Yes, you can modify data in existing Excel workbooks while preserving the original template structure and formulas, ensuring consistent formatting and deterministic formula usage are maintained.

Does pandas work with openpyxl for reading and analyzing Excel files?▼

Pandas works alongside openpyxl to read, analyze, and summarize Excel data, enabling structured spreadsheet workflows for data analytics and reporting tasks.

What is the best way to handle multi-sheet workbooks and data visualization in Excel?▼

The best way to handle multi-sheet workbooks and data visualization is through automated Python scripts that build, modify, and apply standardized visuals to Excel files programmatically.

When do I need to use LibreOffice for Excel spreadsheet workflows?▼

You need LibreOffice when running the recalc.py script to recalculate formulas on demand, ensuring deterministic formula values are computed without opening the Excel application directly.