xlsx

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

25|17|Updated Feb 14, 2026
One-click install
npx skills add https://github.com/QvvvvvvQ/skills_leaks --skill xlsx-qvvvvvvq
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/QvvvvvvQ/skills_leaks/tree/main/GLM/skills/xlsx
Command: npx skills add https://github.com/QvvvvvvQ/skills_leaks --skill xlsx-qvvvvvvq

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 empowers users to create, edit, and analyze complex spreadsheet files, handling everything from basic data entry to intricate financial modeling and visualization.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new .xlsx files with custom formulas, formatting, and data. Modify existing spreadsheets while preserving their structure and formulas.
  • Data Analysis & Visualization: Read, analyze, and process data within spreadsheets using libraries like pandas. Create charts and visualizations based on the data.
  • Formula Recalculation & Verification: Ensure all formulas are correctly calculated and validated using LibreOffice, preventing common errors like #REF! or #DIV/0!.
  • Use Case: A financial analyst needs to build a complex revenue projection model. They can use this Skill to create a new Excel file, input assumptions, define formulas for growth rates and margins, apply industry-standard formatting, and then verify all calculations using the provided recalculation script.

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 sample 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 file with formulas and formatting?

To create an Excel file with formulas and formatting, you can generate new .xlsx files using openpyxl to define custom formulas, input data, and apply advanced formatting while preserving the spreadsheet structure.

Can I use pandas for spreadsheet data analysis and visualization?

Yes, you can use pandas for spreadsheet data analysis and visualization to read, process, and analyze data within .xlsx, .xlsm, .csv, and .tsv files, enabling efficient data reporting and chart creation.

What is the best way to verify Excel formula calculations and avoid errors?

The best way to verify Excel formula calculations and avoid errors like #REF! or #DIV/0! is using the provided recalc.py script, which validates and recalculates formulas via LibreOffice to ensure accurate financial modeling.

Does this spreadsheet management approach support modifying existing .xlsx files?

Yes, this spreadsheet management approach supports modifying existing .xlsx files, allowing you to edit data and update financial models while preserving the original file structure and formulas.

How do I build a revenue projection model in a spreadsheet?

You build a revenue projection model in a spreadsheet by creating a new Excel file, inputting growth assumptions, defining formulas for margins, applying formatting, and verifying all calculations using the recalculation script.

What file formats are supported for data manipulation and reporting?

Supported file formats for data manipulation and reporting include .xlsx, .xlsm, .csv, and .tsv, allowing comprehensive spreadsheet management, data analysis via pandas, and formula recalculation using LibreOffice.