xlsx

Create and edit Excel-compatible spreadsheets while preserving formulas and formatting.

Updated Mar 24, 2025
One-click install
npx skills add https://github.com/Leon0050/m_pro --skill xlsx-leon0050
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Leon0050/m_pro/tree/main/llm/trae/xlsx
Command: npx skills add https://github.com/Leon0050/m_pro --skill xlsx-leon0050

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

This Skill enables automated creation, modification, and analysis of Excel-compatible spreadsheets without losing formulas or formatting, reducing repetitive workbook maintenance and manual errors.

Core Features & Use Cases

  • Automated workbook creation with formulas and formatting preserved across .xlsx, .xlsm, and .csv/.tsv exports.
  • Modify existing workbooks while maintaining templates and styles to ensure consistency across reports.
  • Data analysis and reporting workflows using Python tools (e.g., openpyxl, pandas) with optional recalculation via recalc.py for up-to-date formulas.

Quick Start

Create a new Excel workbook from provided data with formulas preserved and formatting applied.

Frequently Asked Questions about xlsx

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Excel spreadsheet creation while preserving formulas and formatting?

To automate Excel spreadsheet creation while preserving formulas and formatting, this Skill uses openpyxl to programmatically generate .xlsx, .xlsm, and .csv files, applying templates and styles to ensure consistency across reports without manual errors.

Can I edit existing .xlsx workbooks without breaking formatting or formulas?

Yes, you can edit existing .xlsx workbooks without breaking formatting or formulas. This Skill modifies workbooks while maintaining templates and styles, ensuring formatting consistency across reports during data modification workflows.

Does openpyxl support recalculation of formulas for up-to-date data analysis?

openpyxl supports formula preservation and manipulation, and this Skill includes a recalc.py script for recalculation to ensure up-to-date formulas during data analysis and reporting workflows.

What is the best way to automate budgeting and forecasting across Excel-compatible formats?

The best way to automate budgeting and forecasting across Excel-compatible formats is using this Skill to apply automated workbook creation, data cleaning, and recalculation, preserving formulas and formatting across .xlsx, .xlsm, and .csv exports.

Do I need Python and openpyxl to run automated spreadsheet analysis workflows?

Yes, you need Python and openpyxl to run automated spreadsheet analysis workflows. This Skill depends on openpyxl for manipulating Excel-compatible formats, applying formatting, preserving formulas, and executing data analysis workflows.

What are the limitations of using openpyxl for spreadsheet automation?

Limitations of using openpyxl for spreadsheet automation include potential constraints with complex legacy Excel features, though this Skill mitigates formula staleness by providing a recalc.py script for up-to-date recalculation during data analysis.