xlsx

Create, modify, and analyze Excel workbooks with openpyxl, pandas, and Playwright.

264|11|Updated Apr 25, 2026
One-click install
npx skills add https://github.com/rkz91/coco --skill xlsx-rkz91
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/rkz91/coco/tree/main/skills/xlsx
Command: npx skills add https://github.com/rkz91/coco --skill xlsx-rkz91

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, playwright.

What problem does it solve?

Spreadsheets are the backbone of data, reporting, and forecasting, yet creating, formatting, and maintaining Excel workbooks manually is error-prone and time-consuming.

Core Features & Use Cases

  • Programmatic creation, editing, and analysis of workbooks using openpyxl and pandas to automate data pipelines, formulas, and formatting.
  • Browser-based automation with Excel Online via Playwright to collaborate, build charts, and create pivot tables without local tooling.
  • Enforce formatting standards, consistent numbering, and robust formula handling across templates and reports.

Quick Start

Create a new workbook and populate it with data, formatting, and formulas using either Python (openpyxl/pandas) or an Excel Online workflow.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel workbook creation and formatting using Python?

Automate Excel workbook creation and formatting programmatically using openpyxl and pandas to build data pipelines, apply formulas, and enforce consistent numbering across reports. This approach handles .xlsx, .xlsm, and .csv files without manual spreadsheet editing.

Can I use Playwright to automate Excel Online workflows in the browser?

Automate Excel Online workflows via Playwright to collaborate, build charts, and create pivot tables directly in the browser. This enables browser-based spreadsheet automation without requiring local tooling or desktop application access.

What is the best way to generate financial models from .xlsx and .csv files?

Generate financial models from .xlsx and .csv files by applying openpyxl and pandas for data handling and formula application. This method ensures robust formatting standards and consistent template management across financial reports.

Does this approach support applying formulas and formatting standards across existing spreadsheet templates?

Applying formulas and formatting standards across existing spreadsheet templates is fully supported using openpyxl. It allows programmatic modification of workbooks to enforce consistent numbering, robust formula handling, and standardized report formatting.

Can I combine pandas data analysis with spreadsheet formatting in a single workflow?

Combine pandas data analysis with spreadsheet formatting in a single workflow by using pandas for data manipulation and openpyxl for workbook styling and formula application. This integration streamlines end-to-end report generation and data pipeline automation.

What are the limitations of using openpyxl and pandas for Excel automation?

Limitations of using openpyxl and pandas for Excel automation include potential constraints with complex browser-based collaboration features, which require a Playwright-based Excel Online workflow instead of local programmatic file handling.