skills.rest
AIDC-AI
AIDC-AIOFFICIAL
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze Excel spreadsheets with formulas and pandas.

16|7|Updated Feb 6, 2026
Search Tags:#automation#financial modeling#reporting#data analysis#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/AIDC-AI/Pixelle-Studio --skill xlsx-aidc-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/AIDC-AI/Pixelle-Studio/tree/main/backend/skills/default/xlsx
Command: npx skills add https://github.com/AIDC-AI/Pixelle-Studio --skill xlsx-aidc-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers users to create, edit, and analyze complex Excel spreadsheets using natural language, eliminating the need for manual formula creation and data manipulation.

Core Features & Use Cases

  • Dynamic Spreadsheet Creation: Generate new .xlsx files with formulas, formatting, and data.
  • Intelligent Editing: Modify existing spreadsheets while preserving formulas and structure.
  • Data Analysis & Visualization: Perform data analysis and create visualizations directly within spreadsheets.
  • Formula Recalculation & Error Checking: Automatically recalculate formulas and identify/fix common Excel errors.
  • Use Case: Automatically generate a financial projection model in Excel based on provided assumptions, ensuring all formulas are correctly implemented and validated.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', 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 create an Excel financial model with formulas using natural language?▼

You can create an Excel financial model by providing your assumptions in natural language. The tool generates a new .xlsx file with correctly implemented formulas, formatting, and validated data structures without manual input.

Can I edit existing xlsx files without breaking formulas and formatting?▼

Editing existing xlsx files preserves formulas and structure while applying your modifications. The tool intelligently updates spreadsheet content and uses LibreOffice to automatically recalculate formulas and identify common errors.

Does pandas work with csv and tsv files for spreadsheet data analysis?▼

Pandas works directly with csv and tsv files for spreadsheet data analysis. The tool leverages pandas to perform data manipulation and analysis, supporting these formats alongside standard .xlsx and .xlsm Excel files.

What is the best way to automate Excel report generation and error checking?▼

Automating Excel report generation is best handled by using natural language to define columns and data. The tool automatically populates the spreadsheet, applies formatting, and performs robust error checking using LibreOffice for formula recalculation.

How do spreadsheet automation tools handle formula recalculation and error fixing?▼

Spreadsheet automation tools handle formula recalculation by integrating LibreOffice to process and validate formulas. This mechanism automatically identifies and fixes common Excel errors during both file creation and intelligent editing workflows.

Are there limitations when modifying xlsm files compared to xlsx spreadsheets?▼

Modifying xlsm files shares the same intelligent editing capabilities as xlsx spreadsheets, preserving formulas and structure. However, users should ensure LibreOffice is properly configured to support robust formula recalculation across both formats.

Related Skills

Explore More Finance & Accounting Skills→
MuduiClawMuduiClaw
11

xlsx

Create, edit, and analyze Excel spreadsheets with formulas and pandas.

Community
Advanced
rangerrick337rangerrick337
10

xlsx

Automate Excel spreadsheet creation, editing, and analysis with formula integrity across .xlsx, .xlsm, .csv, and .tsv.

Community
Advanced
snake-dev-teamsnake-dev-team

ck:xlsx

Manages Excel file creation, editing and analysis with pandas and openpyxl.

Official
Advanced
pacphipacphi
14

xlsx

Create, edit, and analyze Excel workbooks with formulas and pandas.

Community
Advanced