xlsx

Automate Excel spreadsheet creation, modification, and analysis with Python.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/seanng23/oblique-power-skills --skill xlsx-seanng23
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/seanng23/oblique-power-skills/tree/main/oblique-cowork/skills/xlsx
Command: npx skills add https://github.com/seanng23/oblique-power-skills --skill xlsx-seanng23

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill simplifies complex spreadsheet operations, enabling users to manipulate and analyze data quickly and accurately, without extensive Excel expertise.

Core Features & Use Cases

  • Data Analysis: Utilize pandas for powerful data manipulation and visualization.
  • File Operations: Open, read, edit, and save .xlsx, .xlsm, .csv, and .tsv files.
  • Formatting Standards: Enforce professional formatting, color coding, and number formats.
  • Use Case: Create a financial model from scratch, or analyze and optimize an existing spreadsheet with advanced formulas and charts.

Quick Start

Use the xlsx skill to create a new spreadsheet and fill it with the following data: | Name | Age | Income | |------|-----|--------| | John | 25 | $50,000| | Jane | 30 | $60,000|

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation and data analysis with Python?

Automate Excel spreadsheet creation and data analysis using Python by leveraging pandas for manipulation and openpyxl for formatting. This handles reading, writing, and modifying .xlsx files programmatically without manual Excel work.

Can I use pandas to read and write .xlsx, .csv, and .tsv files?

Yes, pandas can read and write .xlsx, .csv, and .tsv files. When working with .xlsx files specifically, it integrates with openpyxl and LibreOffice to handle data operations and enforce professional spreadsheet formatting standards.

Does spreadsheet automation require LibreOffice to apply formatting and formulas?

Full spreadsheet automation functionality requires LibreOffice alongside pandas and openpyxl. This combination ensures proper handling of advanced functions, color coding, and professional formatting standards when modifying Excel files.

What's the best way to build a financial model from scratch using Python?

Build a financial model from scratch using Python by utilizing pandas for core data manipulation and openpyxl for applying advanced formulas, charts, and formatting. This automates complex financial modeling tasks directly within .xlsx files.

How to enforce professional number formats and color coding in Excel automation?

Enforce professional number formats and color coding in Excel automation by applying openpyxl formatting rules through Python scripts. This allows you to programmatically standardize the visual layout and data presentation of your spreadsheets.