skills.rest
Aiden-Kwak
Aiden-KwakCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create, edit, and analyze spreadsheet files using pandas and openpyxl.

Updated Feb 15, 2026
Search Tags:#financial modeling#data analysis#pandas#openpyxl#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/Aiden-Kwak/Bob-Skills --skill xlsx-aiden-kwak
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Aiden-Kwak/Bob-Skills/tree/main/.cursor/skills/xlsx
Command: npx skills add https://github.com/Aiden-Kwak/Bob-Skills --skill xlsx-aiden-kwak

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, python-docx, python-pptx, lxml, defusedxml, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines complex spreadsheet tasks, from data cleaning and formula creation to advanced financial modeling, eliminating manual errors and saving significant time.

Core Features & Use Cases

  • Data Analysis & Manipulation: Use pandas for reading, analyzing, and writing Excel files.
  • Formula Creation & Management: Leverage openpyxl to insert formulas, ensuring accuracy and dynamic updates.
  • Formula Recalculation & Error Checking: Utilize scripts/recalc.py to validate and fix formula errors like #REF!, #DIV/0!, etc.
  • Use Case: Automatically clean messy tabular data, calculate growth rates using Excel formulas, format financial reports with industry-standard color coding, and ensure zero formula errors in the final deliverable.

Quick Start

Use the xlsx skill to read the data from the file named 'sales_data.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 formula creation and recalculation in Python?▼

Automate Excel formula creation and recalculation by using pandas for data manipulation and openpyxl for inserting formulas. The process validates formula errors like #REF! and #DIV/0! via a mandatory recalculation script using LibreOffice to ensure accuracy.

Can I read, clean, and write messy CSV or TSV tabular data files?▼

You can read, clean, and write CSV and TSV tabular data files using pandas. The workflow streamlines data analysis and manipulation tasks, eliminating manual errors when processing messy spreadsheet formats from various data sources.

What's the best way to fix Excel formula errors like #REF! and #DIV/0!?▼

The best way to fix Excel formula errors like #REF! and #DIV/0! is utilizing a dedicated recalculation script. This method validates and fixes formula errors automatically, ensuring zero formula errors in the final spreadsheet deliverable.

Does this spreadsheet automation approach support financial modeling and formatting?▼

This spreadsheet automation approach supports financial modeling by leveraging openpyxl to insert formulas and apply industry-standard color coding. It calculates growth rates and formats financial reports while ensuring dynamic updates and formula accuracy.

Can I create a new spreadsheet from scratch or convert other data sources into xlsx?▼

You can create new spreadsheets from scratch or convert other data sources into xlsx format. The process supports opening, reading, editing, and converting tabular data across .xlsx, .xlsm, .csv, and .tsv formats using pandas and openpyxl.

Related Skills

Explore More Finance & Accounting Skills→
JosephWoodallJosephWoodall
1

xlsx

Process and transform XLSX, CSV, and TSV spreadsheets using openpyxl.

Community
Intermediate
christopherlouetchristopherlouet
5

dev-document

Generate PDF, Word, Excel, and PowerPoint documents from structured data.

Community
Intermediate
robertbr123robertbr123

pptx-author

Generate PowerPoint presentations from Python scripts using python-pptx.

Community
Intermediate
xlsamaxlsama

xlsx

Create, edit, and analyze spreadsheet files using pandas and openpyxl.

Community
Advanced