xlsx

Read, edit, and create Excel .xlsx workbooks via JSON specifications.

6.6k|511|Updated May 6, 2026
One-click install
npx skills add https://github.com/opensquilla/opensquilla --skill xlsx-opensquilla
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/opensquilla/opensquilla/tree/main/src/opensquilla/skills/bundled/xlsx
Command: npx skills add https://github.com/opensquilla/opensquilla --skill xlsx-opensquilla

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill eliminates manual Excel tedium by letting you inspect worksheets, apply targeted cell edits, and generate new workbooks from a simple JSON spec without accidentally breaking formulas or types.

Core Features & Use Cases

  • Workbook inspection for LLM workflows: Export sheet structure and cell data types (including formulas as expressions) to JSON so you can reason over tabular content.
  • Deterministic in-place edits: Apply structured operations to existing .xlsx files (set cells, rename sheets, merge ranges) while preserving types and supporting formula writes.
  • Create-from-scratch via spec: Build a new workbook from rows plus optional merged ranges and freeze panes.
  • Use case: Turn a quarterly revenue plan into an updated workbook by inspecting the existing template, editing only the target cells, and adding computed formulas safely.

Quick Start

Use the xlsx skill to inspect the workbook template at /path/to/book.xlsx and return its sheets, rows, merged ranges, and cell types as JSON.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I edit an existing Excel workbook without breaking formulas?

To edit an Excel workbook without breaking formulas, apply deterministic in-place cell operations that preserve existing cell types and formula expressions. This targeted approach updates specific cells while maintaining spreadsheet integrity.

What is the best way to extract worksheet structure and cell data types into JSON?

Extracting worksheet structure into JSON involves reading the Excel workbook and exporting sheet rows, merged ranges, and cell types. This mechanism preserves formulas as expressions for reasoning over tabular content.

Can I generate a new Excel spreadsheet from a JSON specification?

You can generate a new Excel spreadsheet from a JSON specification by defining rows, merged ranges, and freeze panes. This programmatic workbook authoring supports typed cell values and formula writing.

Does openpyxl support writing formulas and ISO date coercion when creating xlsx files?

Yes, openpyxl-backed helpers support writing formula expressions and handling ISO date coercion when creating xlsx files. They preserve cell typing during both workbook inspection and spreadsheet editing operations.

What are the limitations of converting Excel worksheets to JSON for analysis?

Converting Excel worksheets to JSON requires openpyxl-backed helpers for inspect, edit, and create paths. Limitations include relying on deterministic cell operations and JSON specifications rather than direct spreadsheet manipulation.