skills.rest
coffee3699
coffee3699COMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

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

Updated Aug 23, 2026
Search Tags:#data analysis#Excel#formulas#spreadsheet#financial analysis
One-click install
npx skills add https://github.com/coffee3699/spreadsheet_rag --skill xlsx-coffee3699
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/coffee3699/spreadsheet_rag/tree/main/agentic_analysis/pipeline/mini_agent_service/mini_agent/skills/document-skills/xlsx
Command: npx skills add https://github.com/coffee3699/spreadsheet_rag --skill xlsx-coffee3699

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the complex tasks of spreadsheet creation, editing, and analysis, enabling efficient management of formulas, formatting, and data operations.

Core Features & Use Cases

  • Spreadsheet Creation: Build new spreadsheets with formulas, formatting, and data visualization capabilities.
  • Data Analysis: Perform data analysis and visualization directly within Excel files.
  • File Modification: Edit existing spreadsheets while preserving formulas and formatting.
  • Use Case: For a financial analyst, this Skill can be used to create a new investment analysis spreadsheet, analyze data from a financial model, or modify an existing budget template.

Quick Start

Use the xlsx skill to create a new spreadsheet for financial analysis and apply formulas for net present value calculations.

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 spreadsheet with formulas for financial analysis?▼

Use this Skill to build new Excel spreadsheets with advanced formula support, formatting, and data visualization tailored for financial analysis and business planning scenarios.

Can I edit existing Excel files while preserving formulas and formatting?▼

Yes, you can edit existing Excel files while preserving formulas and formatting. The Skill modifies spreadsheets by reading and writing files using openpyxl and pandas without losing existing data structures.

What Python libraries are required for spreadsheet data analysis and manipulation?▼

Spreadsheet data analysis and manipulation require pandas and openpyxl. These Python dependencies enable the reading, writing, and modifying of Excel files within the data analysis workflow.

Does pandas work with openpyxl for applying Excel formulas like net present value calculations?▼

Pandas works with openpyxl to apply Excel formulas like net present value calculations. The Skill leverages both libraries to support comprehensive spreadsheet operations and advanced formula execution.

What is the best way to perform data visualization directly within Excel files?▼

The best way to perform data visualization directly within Excel files is using this Skill's creation and editing features, which integrate visualization capabilities into the spreadsheet generation process for financial models.

Related Skills

Explore More Finance & Accounting Skills→
bobmatnycbobmatnyc
68

xlsx

Read, write, and convert Excel files with Python and JavaScript.

Community
Intermediate
run6270run6270
1

Excel Analysis

Analyze and manipulate Excel spreadsheet data with pandas and openpyxl.

Community
Intermediate
locdinh209locdinh209

xlsx

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

Community
Advanced
bowoxdailybowoxdaily

xlsx

Analyze Excel files and generate reports using Python and openpyxl.

Community
Advanced