skills.rest
ronniwheellike973
ronniwheellike973COMMUNITY
Explore all skills by this author →
GitHub

xlsx

Manage and analyze .xlsx files with pandas, openpyxl, and formula recalculation.

2|1|Updated Nov 25, 2025
Search Tags:#financial modeling#data analysis#formulas#spreadsheet#xlsx
One-click install
npx skills add https://github.com/ronniwheellike973/Mini-Agent --skill xlsx-ronniwheellike973
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/ronniwheellike973/Mini-Agent/tree/main/mini_agent/skills/document-skills/xlsx
Command: npx skills add https://github.com/ronniwheellike973/Mini-Agent --skill xlsx-ronniwheellike973

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 spreadsheet creation, editing, and analysis, allowing users to efficiently manage and interpret data.

Core Features & Use Cases

  • Spreadsheet Creation: Build new spreadsheets with formulas and formatting, ensuring a dynamic and updateable spreadsheet.
  • Data Analysis: Perform in-depth data analysis and visualization within spreadsheets.
  • Use Case: If you need to analyze financial data, create detailed financial models, or visualize data trends, this Skill can help.

Quick Start

Use the xlsx skill to create a new financial model with a cash flow statement and balance sheet, based on the data provided in 'financial_data.csv'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I recalculate formulas in an existing xlsx spreadsheet using Python?▼

To recalculate xlsx formulas, this Skill utilizes LibreOffice to process the file and evaluate formula results, while pandas and openpyxl handle the underlying data manipulation and formatting. This ensures dynamic spreadsheet updates.

Can I build a financial model with a balance sheet and cash flow statement from a CSV file?▼

Yes, you can create a financial model with a balance sheet and cash flow statement from a CSV file. The Skill parses input data with pandas and structures it into a formatted xlsx workbook using openpyxl.

What is the best way to perform data analysis and visualization within a spreadsheet?▼

The best way to perform data analysis and visualization within a spreadsheet is using this Skill's integrated pandas backend for data manipulation and openpyxl for applying visual formatting directly to the xlsx file.

Do I need LibreOffice installed to manage and analyze xlsx files?▼

Yes, you need LibreOffice installed specifically for formula recalculation. While pandas and openpyxl manage data manipulation and formatting, LibreOffice is required to accurately evaluate and update formula values.

How to handle data manipulation for financial modeling in Python spreadsheets?▼

To handle data manipulation for financial modeling, the Skill leverages pandas to process the dataset and openpyxl to apply formulas and formatting, resulting in a comprehensive and updateable xlsx spreadsheet.

Related Skills

Explore More Finance & Accounting Skills→
Jaydpatel01Jaydpatel01

xlsx

Create, edit, and analyze spreadsheet files in .xlsx, .xlsm, .csv, and .tsv formats.

Community
Advanced
rangerrick337rangerrick337
10

xlsx

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

Community
Advanced
cheatcode-aicheatcode-ai
15

csv-analyst

Analyze CSV and XLSX files to generate statistical profiles and visual insights.

Official
Intermediate
rezosndrezosnd

excel-generator

Generate styled Excel workbooks with formulas, charts, and data validation.

Community
Intermediate