skills.rest
zjy-dev
zjy-devCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

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

2|Updated Feb 27, 2026
Search Tags:#financial modeling#data analysis#pandas#spreadsheet#excel
One-click install
npx skills add https://github.com/zjy-dev/simpler --skill xlsx-zjy-dev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/zjy-dev/simpler/tree/main/.opencode/skills/xlsx
Command: npx skills add https://github.com/zjy-dev/simpler --skill xlsx-zjy-dev

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill simplifies the creation, editing, and analysis of spreadsheets, allowing users to work with data more efficiently.

Core Features & Use Cases

  • Spreadsheets Creation: Build new spreadsheets with formulas and formatting.
  • Data Analysis: Read, analyze, and visualize data within spreadsheets.
  • Use Case: If you need to create a financial model and analyze revenue trends, this Skill can help you quickly set up your spreadsheet, perform calculations, and visualize the data.

Quick Start

Create a new Excel file for financial projections using the xlsx skill.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create and edit Excel spreadsheets using pandas and openpyxl?▼

To create and edit Excel spreadsheets, this Skill uses pandas and openpyxl to handle data input, apply formulas, and manage formatting within .xlsx and .xlsm files. It streamlines spreadsheet creation and modification for financial modeling tasks.

Can I analyze financial data and visualize revenue trends in an Excel file?▼

You can analyze financial data and visualize revenue trends directly within Excel files. This Skill reads and processes spreadsheet data, performing calculations and generating visualizations to support financial modeling and data analysis workflows.

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

Yes, you need LibreOffice installed alongside pandas and openpyxl to recalculate formulas. LibreOffice handles the formula recalculation logic, ensuring that computed values within your spreadsheets remain accurate after data input and edits.

Does this spreadsheet automation tool support CSV and TSV file formats?▼

This spreadsheet automation tool supports CSV and TSV file formats, in addition to .xlsx and .xlsm files. It reads, processes, and analyzes tabular data across these formats for data analysis and financial modeling tasks.

What is the best way to automate financial modeling and data analysis in Excel?▼

The best way to automate financial modeling is by using this Skill to programmatically set up spreadsheets, perform calculations, and visualize data. It integrates pandas and openpyxl to build and edit financial models efficiently.

Related Skills

Explore More Finance & Accounting Skills→
mkurmanmkurman
321

xlsx

Automate spreadsheet manipulation and data cleaning with pandas and openpyxl.

Community
Intermediate
imvladikonimvladikon
3

xlsx

Automate Excel workbook editing with formulas via openpyxl and pandas.

Community
Intermediate
ChatAndBuildChatAndBuild
1

xlsx

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

Official
Advanced
hgxszhj-pixelhgxszhj-pixel
2

minimax-xlsx

Open, create, edit, analyze, and validate Excel files with Python.

Community
Advanced