office-xlsx

Create, inspect, and edit Excel workbooks using Python and openpyxl.

88|15|Updated May 25, 2026
One-click install
npx skills add https://github.com/open-octo/octo-agent --skill office-xlsx-open-octo
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: office-xlsx
Source: https://github.com/open-octo/octo-agent/tree/main/internal/skills/defaults/office-xlsx
Command: npx skills add https://github.com/open-octo/octo-agent --skill office-xlsx-open-octo

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill removes the repetitive and error-prone work of creating, inspecting, and editing Excel workbooks programmatically, while keeping formulas, formatting, charts, and data validation organized.

Core Features & Use Cases

  • Workbook Inspection: Examine sheets, dimensions, headers, sample rows, formulas, and merged cells before making changes.
  • Workbook Editing: Create or modify cells, rows, sheets, formulas, styles, merges, dimensions, freeze panes, validations, and charts through structured operations.
  • Use Case: Build a financial budget workbook with formatted assumptions, self-updating formulas, a summary chart, and validated input fields, or update an existing spreadsheet while preserving its structure.

Quick Start

Ask the office-xlsx skill to inspect an existing workbook and then apply the required cell, formula, formatting, chart, or validation changes.

Frequently Asked Questions about office-xlsx

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

FAQPage Schema
How do I automate Excel workbook editing with Python without losing formulas and formatting?

Excel workbook automation is achieved by applying structured JSON operations through bundled scripts to modify cells, formulas, and formatting programmatically. This preserves existing structures while enabling bulk updates across multiple sheets without manual intervention.

Can I add data validation and charts to an xlsx file using openpyxl?

Yes, you can add data validation and charts to an xlsx file using openpyxl. The Skill supports creating validated input fields and summary charts programmatically, alongside standard workbook editing tasks like styling and merging cells.

What is the best way to inspect an existing spreadsheet before applying bulk updates?

The best way to inspect an existing spreadsheet is to examine its sheets, dimensions, headers, sample rows, formulas, and merged cells programmatically before making changes. This ensures structural preservation during downstream workbook editing operations.

Does this spreadsheet automation approach evaluate formulas or leave calculation to Excel?

This spreadsheet automation approach leaves formula evaluation to Excel-compatible spreadsheet engines rather than calculating values directly. It focuses on creating, inspecting, and editing workbook structures, formulas, and formatting programmatically.

How do I create a financial budget workbook with self-updating formulas and freeze panes?

Create a financial budget workbook by programmatically applying formatted assumptions, self-updating formulas, summary charts, validated input fields, and freeze panes through structured operations. This supports operational, reporting, and financial-modeling workflows.