xlsx

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

Updated Feb 7, 2026
One-click install
npx skills add https://github.com/2898117012/agent-skills --skill xlsx-2898117012
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/2898117012/agent-skills/tree/main/xlsx
Command: npx skills add https://github.com/2898117012/agent-skills --skill xlsx-2898117012

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers users to create, edit, and analyze spreadsheet data efficiently, handling complex formulas, formatting, and data manipulation tasks.

Core Features & Use Cases

  • Spreadsheet Creation: Generate new .xlsx files with data, formulas, and custom formatting.
  • Data Analysis: Read, analyze, and visualize data from existing spreadsheets using pandas.
  • Formula Management: Ensure formula accuracy, preserve existing templates, and recalculate formulas using LibreOffice.
  • Use Case: Analyze sales data from a CSV, create a new Excel report with charts, and ensure all financial formulas are error-free.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add a formula to sum the 'Revenue' column.

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 file with formulas and custom formatting using openpyxl and pandas?

To create an Excel file with formulas and custom formatting, openpyxl and pandas facilitate the generation of .xlsx files with data, formulas, and specific formatting standards. The Skill automates this creation process efficiently.

Do I need LibreOffice to recalculate spreadsheet formulas in an existing Excel template?

Yes, LibreOffice is required to recalculate formulas in an existing Excel template. The Skill uses a specific recalc.py script via LibreOffice to ensure formula accuracy and recalculation within the spreadsheet.

What's the best way to analyze sales data from a CSV and generate a new Excel report?

The best way to analyze sales data from a CSV and generate an Excel report is using pandas for data analysis and openpyxl for file creation. The Skill handles reading, analyzing, and outputting the final spreadsheet.

Can I read, analyze, and visualize data from existing spreadsheets with pandas?

Yes, you can read, analyze, and visualize data from existing spreadsheets with pandas. The Skill supports comprehensive data analysis operations, allowing you to extract and process information from .xlsx, .csv, and .tsv files.

Does this spreadsheet manipulation approach support both .xlsm and .tsv file formats?

Yes, this spreadsheet manipulation approach supports .xlsm and .tsv file formats. The Skill facilitates comprehensive operations across .xlsx, .xlsm, .csv, and .tsv files, ensuring adherence to formatting and error-checking standards.

Why does formula recalculation sometimes not work when preserving existing Excel templates?

Formula recalculation might not work when preserving existing Excel templates if LibreOffice is not installed. The Skill explicitly requires LibreOffice to execute formula recalculation via recalc.py and ensure error-free financial formulas.