xlsx

Create and edit Excel spreadsheets with formulas, charts, and data analysis.

Updated Feb 13, 2026

Search Tags:#automation #data analysis #visualization #spreadsheet #excel #formula

Ready to run

npx skills add https://github.com/Munreader/M-nreader --skill xlsx-munreader

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Munreader/M-nreader/tree/main/skills/xlsx
Command: npx skills add https://github.com/Munreader/M-nreader --skill xlsx-munreader

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, recalc.py, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet files, enabling seamless data management and visualization.

Core Features & Use Cases

Spreadsheet Creation and Modification: Generate new spreadsheets or modify existing ones with formulas, formatting, and data inputs.
Data Analysis and Visualization: Import datasets for analysis, then produce visual representations like charts and tables.
Use Case: You need to prepare a financial report that includes data tables, calculated metrics, and embedded charts. Use this Skill to automate the process from data import to presentation-ready Excel file.

Quick Start

Ask the AI to create or edit an Excel file that summarizes sales data, including calculated totals and a bar chart showing regional performances.

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 and data analysis for business reporting?▼

Automate Excel spreadsheet creation and data analysis by importing datasets, applying formulas, and generating visual charts. This process streamlines data management to produce presentation-ready files with calculated metrics and embedded tables.

Can I use Python to edit an existing Excel file with formulas and calculated metrics?▼

Yes, you can edit existing Excel files with formulas using Python. This Skill modifies spreadsheets by applying formula recalculation through LibreOffice to ensure calculated metrics and data inputs remain accurate.

What's the best way to generate charts and tables from spreadsheet data for a financial report?▼

Generate charts and tables from spreadsheet data by importing the dataset for analysis and producing visual representations. This approach automates the process from data import to a presentation-ready Excel file with regional performance charts.

Does openpyxl support formula recalculation for accurate spreadsheet visualization?▼

Openpyxl supports spreadsheet creation and modification, while formula recalculation is handled through LibreOffice to ensure accuracy. This combination guarantees that calculated metrics in your visualizations are correctly computed.

How do I consolidate and transform spreadsheet data for financial reporting?▼

Consolidate and transform spreadsheet data for financial reporting by importing datasets into pandas for analysis. This workflow enables seamless data management, allowing you to summarize sales data and calculate totals efficiently.

Are there limitations when using pandas for spreadsheet visualization and modification?▼

Pandas handles data import and analysis for spreadsheet visualization, but formula recalculation requires LibreOffice. This ensures accurate calculated metrics when modifying files, though complex formatting may need openpyxl.