xlsx

Read, edit, and save Excel files with pandas and LibreOffice.

Updated Apr 13, 2026
One-click install
npx skills add https://github.com/Syedyasir001/rvu-LIBFLOW --skill xlsx-syedyasir001
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Syedyasir001/rvu-LIBFLOW/tree/main/.agent/skills/library/xlsx
Command: npx skills add https://github.com/Syedyasir001/rvu-LIBFLOW --skill xlsx-syedyasir001

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, scripts/recalc.py, scripts/office/pack.py, scripts/office/unpack.py, scripts/office/validate.py, scripts/office/validators, and includes scripts (resource) and assets (resource) components.

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of Excel files, enabling you to perform a wide range of spreadsheet tasks with a single command.

Core Features & Use Cases

  • Create/Read/Update Excel Files: Perform a suite of operations on Excel files, including opening, reading, editing, and saving changes.
  • Data Analysis: Utilize pandas for data analysis, visualization, and basic operations.
  • File Conversion: Convert between different tabular file formats (e.g., .xlsx, .xlsm, .csv, .tsv).
  • Use Case: Suppose you need to analyze sales data from an Excel file. Use this Skill to load the file, perform calculations, and save the results back to a new spreadsheet.

Quick Start

Use the xlsx skill to calculate the sum of sales for the year 2024 from the file 'sales_data.xlsx'.

Frequently Asked Questions about xlsx

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Excel data analysis and edit xlsx files with a single command?

To automate Excel data analysis and edit xlsx files, you can load the spreadsheet, perform calculations using pandas, and save the updated results back to a new file in one command. This streamlines administrative workflows and data processing.

Can I convert a CSV file to an xlsx spreadsheet format?

Yes, you can convert a CSV file to an xlsx spreadsheet format. The Skill supports file conversion between various tabular formats including .xlsx, .xlsm, .csv, and .tsv, allowing seamless transitions for your data analysis workflows.

Do I need LibreOffice to recalculate spreadsheet formulas in Excel files?

Yes, you need LibreOffice installed to recalculate formulas in Excel files. While pandas handles data analysis, LibreOffice is specifically required to execute and update formula-based calculations within the spreadsheet.

What is the best way to perform financial modeling on an existing Excel file?

The best way to perform financial modeling on an Excel file is to use pandas for data manipulation and analysis. You can open the existing spreadsheet, apply your financial calculations, and save the updated modeling results.

Does this spreadsheet management approach support reading and saving xlsm files?

Yes, this spreadsheet management approach supports reading and saving xlsm files. It handles operations on various tabular formats including .xlsx, .xlsm, .csv, and .tsv, ensuring broad compatibility for data processing.

Why does my pandas data analysis fail when reading a corrupted xlsx file?

Pandas data analysis fails on corrupted xlsx files because the openpyxl dependency requires valid structural integrity to parse the spreadsheet. Ensure the Excel file is not damaged and adheres to standard tabular formatting before loading.