skills.rest
giadaf-boosha
giadaf-booshaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create, edit, and analyze Excel spreadsheets using pandas and openpyxl.

10|1|Updated Feb 19, 2026
Search Tags:#financial modeling#data analysis#Excel#pandas#spreadsheet
One-click install
npx skills add https://github.com/giadaf-boosha/claude-code --skill xlsx-giadaf-boosha
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/giadaf-boosha/claude-code/tree/main/skills/xlsx
Command: npx skills add https://github.com/giadaf-boosha/claude-code --skill xlsx-giadaf-boosha

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet data, making complex tasks manageable and efficient.

Core Features & Use Cases

  • Create and Edit Spreadsheets: Build new spreadsheets from scratch or modify existing ones.
  • Data Analysis: Perform advanced data analysis, including financial modeling and data visualization.
  • Use Case: Suppose you need to analyze a financial model with multiple scenarios. This Skill can help you create the model, input data, perform calculations, and visualize results.

Quick Start

To open an existing spreadsheet and make changes, use the xlsx skill with the command: xlsx open file.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 spreadsheet creation?▼

You can automate Excel data analysis and spreadsheet creation using this Skill, which leverages pandas for data manipulation and openpyxl for formatting and formulas to streamline financial modeling tasks.

What is the best way to build a financial model with multiple scenarios in Excel?▼

Building a financial model with multiple scenarios in Excel is best handled by automating spreadsheet creation, inputting data, performing calculations, and visualizing results using integrated pandas and openpyxl libraries.

Do I need LibreOffice to recalculate formulas in my Excel spreadsheet?▼

Yes, you need LibreOffice installed to perform formula recalculations in your Excel spreadsheet, as the Skill relies on it alongside openpyxl and pandas for complete file manipulation and analysis.

Can I use pandas to modify an existing Excel file?▼

Yes, you can use pandas to modify an existing Excel file by opening it with the xlsx command, which supports reading, writing, and manipulating spreadsheet data for advanced data analysis tasks.

Does openpyxl support advanced spreadsheet formatting and formulas?▼

openpyxl supports advanced spreadsheet formatting and formulas, allowing you to build new spreadsheets from scratch or modify existing ones while automating data visualization and financial modeling calculations.

Why does my spreadsheet formula not update after editing with Python?▼

Your spreadsheet formula might not update after editing with Python because formula recalculations require LibreOffice; ensure it is installed in your environment to automatically refresh calculated values.

Related Skills

Explore More Data & Analytics Skills→
w7panelw7panel
182

xlsx

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

Official
Advanced
kk580kkkk580kk
1

xiaoyi-xlsx

Automate Excel spreadsheet operations for data manipulation, analysis, and visualization.

Community
Advanced
PetriLahdelmaPetriLahdelma
2

data-science

Guide analytics, data processing, and ML modeling with pandas and scikit-learn.

Community
Advanced
rezosndrezosnd

excel-generator

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

Community
Intermediate