skills.rest
sidart10
sidart10COMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create, edit, and analyze Excel spreadsheet files with formulas.

1|Updated Dec 18, 2025
Search Tags:#financial modeling#data analysis#pandas#openpyxl#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/sidart10/orion-slackbot --skill xlsx-sidart10
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/sidart10/orion-slackbot/tree/main/.skills/xlsx
Command: npx skills add https://github.com/sidart10/orion-slackbot --skill xlsx-sidart10

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers users to create, edit, and analyze spreadsheet files (.xlsx, .xlsm, .csv, .tsv) with advanced formula support, formatting, and data manipulation capabilities, eliminating manual spreadsheet drudgery.

Core Features & Use Cases

  • Formula Creation & Management: Generate complex Excel formulas, ensuring zero errors and preserving existing templates.
  • Data Analysis & Visualization: Utilize pandas for in-depth data analysis and create visualizations directly within spreadsheets.
  • Use Case: Automatically generate a financial projection model in Excel, complete with industry-standard color coding, number formatting, and dynamic formulas that recalculate based on user-defined assumptions.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and populate it with the provided sales data.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I generate Excel formulas and ensure recalculation without breaking existing templates?▼

To generate Excel formulas while preserving existing templates, this Skill creates complex formulas and uses recalculation scripts to ensure formula integrity, guaranteeing zero errors and accurate dynamic updates within your spreadsheet.

Can I use pandas for data analysis directly within an xlsx file?▼

Yes, you can use pandas for data analysis directly within xlsx files. This Skill facilitates in-depth data manipulation and enables you to create visualizations seamlessly inside your Excel spreadsheets.

What is the best way to build a financial modeling spreadsheet with industry-standard formatting?▼

The best way to build financial modeling spreadsheets is using this Skill, which applies specific industry-standard color-coding and number formatting while generating dynamic formulas that recalculate based on user assumptions.

Does openpyxl support advanced formatting and editing for csv and xlsm files?▼

Yes, openpyxl supports advanced formatting and editing for csv and xlsm files. This Skill leverages openpyxl dependencies to facilitate comprehensive spreadsheet operations across xlsx, xlsm, csv, and tsv formats.

How do I automate sales report creation and populate Excel columns with custom data?▼

You automate sales report creation by instructing this Skill to generate a new xlsx spreadsheet, define columns like Date and Revenue, and automatically populate the sheet with your provided custom data.

Related Skills

Explore More Finance & Accounting Skills→
EvezArtEvezArt
3

xlsx

Create, modify, and analyze Excel files using pandas and openpyxl.

Community
Advanced
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
snake-dev-teamsnake-dev-team

ck:xlsx

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

Official
Advanced
ChatAndBuildChatAndBuild
1

xlsx

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

Official
Advanced