xlsx

Automate Excel workbook creation, editing, and analysis with formulas and formatting.

Updated Dec 26, 2025

Search Tags:#automation #pandas #openpyxl #formulas #excel #data-analysis #xlsx

Ready to run

npx skills add https://github.com/yutaoshao/agent-skills --skill xlsx-yutaoshao

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/yutaoshao/agent-skills/tree/main/glm-skills/document-skills/xlsx
Command: npx skills add https://github.com/yutaoshao/agent-skills --skill xlsx-yutaoshao

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the manual drudgery of creating, editing, and analyzing spreadsheets, ensuring formulas stay intact and data remains consistent across workflows.

Core Features & Use Cases

Create new workbooks with formulas and formatting to standard templates.
Edit existing spreadsheets while preserving formulas and data integrity.
Analyze data and generate insights with built-in visualization guidance and export-ready outputs.

Quick Start

Create a new workbook, add a simple formula, and save it as output.xlsx.

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?▼

Automate Excel workbook creation by using this Skill to generate new .xlsx files with intact formulas and applied formatting, eliminating manual data entry errors and ensuring template consistency.

Can I edit existing .xlsm spreadsheets without breaking data integrity?▼

Edit existing .xlsm spreadsheets while preserving formulas and maintaining data integrity. The Skill automates modifications across .xlsx, .xlsm, and .csv workflows without corrupting existing cell logic.

What is the best way to analyze Excel data and generate reporting insights?▼

Analyze Excel data and generate insights using built-in visualization guidance and export-ready outputs. This Skill streamlines spreadsheet workflows for financial modeling and scenario analysis.

Does this spreadsheet automation approach work with pandas and openpyxl?▼

Yes, this Skill integrates with Python tools like pandas and openpyxl. It leverages the recalc.py workflow for formula recalculation, enabling automated data cleaning and analysis.

How do I recalculate formulas in xlsx files after automated data cleaning?▼

Recalculate formulas in xlsx files by leveraging the integrated recalc.py workflow. This ensures formula accuracy and data consistency after automated edits and data cleaning operations.