skills.rest
MadLeon
MadLeonCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze Excel files with pandas and openpyxl.

Updated Nov 1, 2025
Search Tags:#data analysis#pandas#openpyxl#excel#libreoffice
One-click install
npx skills add https://github.com/MadLeon/manufacturing_process_schedule --skill xlsx-madleon
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/MadLeon/manufacturing_process_schedule/tree/main/.github/skills/xlsx
Command: npx skills add https://github.com/MadLeon/manufacturing_process_schedule --skill xlsx-madleon

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 files, automating complex tasks and ensuring accuracy.

Core Features & Use Cases

  • Excel File Creation and Editing: Build new spreadsheets or modify existing ones with advanced formatting and formula capabilities.
  • Data Analysis: Utilize pandas for data manipulation, visualization, and statistical analysis.
  • File Conversion: Convert between various tabular file formats, including .xlsx, .xlsm, .csv, and .tsv.
  • Use Case: If you need to analyze sales data from a .xlsx file and create a comprehensive report, this Skill can automate the entire process.

Quick Start

Create a new Excel file with the following data: 'A1' = 'Product', 'B1' = 'Price', 'C1' = 'Quantity'. Then, calculate the total price for each product.

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 pandas and openpyxl?▼

You can automate Excel file creation and editing by using pandas for data manipulation and openpyxl for advanced formatting and formula capabilities. This Skill builds new spreadsheets or modifies existing ones with precision.

Can I convert between xlsx, csv, and tsv file formats automatically?▼

Yes, you can convert between various tabular file formats including .xlsx, .xlsm, .csv, and .tsv. The Skill uses LibreOffice to handle comprehensive file conversion tasks automatically.

How do I analyze Excel data and calculate formulas from a spreadsheet?▼

To analyze Excel data and calculate formulas, you utilize pandas for data manipulation and statistical analysis. The Skill automates formula recalculation and processes data from your existing .xlsx files.

Do I need LibreOffice installed to manage and manipulate Excel files?▼

Yes, you need LibreOffice installed along with pandas and openpyxl to manage and manipulate Excel files. These dependencies are required for comprehensive file operations including format conversion and formula recalculation.

What is the best way to generate a data analysis report from an xlsx file?▼

The best way to generate a data analysis report from an xlsx file is using this Skill to automate the entire process. It handles data manipulation, visualization, and statistical analysis using pandas to create comprehensive reports.

Related Skills

Explore More Data & Analytics Skills→
jeffpeckyjeffpecky

xlsx

Automate Excel workflows with pandas and openpyxl for data analysis and editing.

Community
Advanced
HwFeeHwFee

data-analyst

Analyze CSV, Excel, JSON, and SQL datasets to generate visual insights and reports.

Community
Intermediate
States-MediaStates-Media

Excel Analysis

Analyze Excel spreadsheets with pandas and openpyxl for reports and charts.

Official
Intermediate
yahav123147yahav123147

xlsx

Clean and repair Excel/CSV spreadsheets with formula recalculation via LibreOffice.

Community
Advanced