xlsx

Create and edit Excel files with formulas and pandas analysis.

43|6|Updated Jan 22, 2026
One-click install
npx skills add https://github.com/MarcelLeon/skills-zh --skill xlsx-marcelleon
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/MarcelLeon/skills-zh/tree/main/skills/xlsx
Command: npx skills add https://github.com/MarcelLeon/skills-zh --skill xlsx-marcelleon

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of Excel spreadsheets, eliminating manual formula errors and complex data manipulation.

Core Features & Use Cases

  • Automated Spreadsheet Creation: Generate new .xlsx files with data, formulas, and formatting.
  • Data Analysis & Visualization: Use pandas for in-depth data analysis and insights.
  • Formula Recalculation & Error Checking: Ensure accuracy with LibreOffice-powered formula recalculation and error detection.
  • Use Case: Automatically create a financial forecast spreadsheet, populate it with data, apply correct formulas, and verify that all calculations are error-free.

Quick Start

Use the xlsx skill to create a new Excel file named 'sales_report.xlsx' with columns 'Product', 'Quantity', and 'Price', and populate it with the provided sales data.

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 with formulas and data validation?

To automate Excel spreadsheet creation, this tool generates new .xlsx files populated with data, applies correct formulas, and enforces data validation rules. It uses openpyxl for structural manipulation to ensure formatting standards are met.

Can I use pandas for data analysis on existing .xlsx and .csv files?

Yes, you can use pandas for data analysis on existing .xlsx and .csv files. It provides in-depth data analysis and visualization capabilities to extract insights directly from your spreadsheet data.

Does LibreOffice integration support formula recalculation and error checking?

Yes, LibreOffice integration supports formula recalculation and error checking. A dedicated script processes your Excel files to recalculate formulas and detect calculation errors, ensuring your financial modeling is accurate.

What is the best way to build a financial forecast spreadsheet with specific formatting standards?

The best way to build a financial forecast spreadsheet is using this skill's financial modeling capabilities. It automatically populates data, applies correct formulas, enforces specific color-coding, and verifies calculations are error-free.

What file formats are supported for spreadsheet management and financial modeling?

Supported file formats for spreadsheet management include .xlsx, .xlsm, .csv, and .tsv. This allows comprehensive creation, editing, and analysis across various spreadsheet file types for financial modeling.