skills.rest
truongnat
truongnatCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create, inspect, edit, and validate Excel .xlsx files with coverage manifests using Python openpyxl.

Updated Jul 28, 2026
Search Tags:#python#validation#openpyxl#spreadsheet#excel#xlsx#coverage manifest
One-click install
npx skills add https://github.com/truongnat/Restly --skill xlsx-truongnat
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/truongnat/Restly/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/truongnat/Restly --skill xlsx-truongnat

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve? Working with Excel files programmatically risks silent data loss when unsupported parts like macros, OLE objects, or signatures are present. This Skill enforces a supported-lossless contract: every create or edit operation must produce a coverage manifest proving coverage_ratio equals 1.0 before the file is published. ## Core Features & Use Cases - Inspect and Validate: Inventory all OOXML package parts, sheets, cells, and merged ranges in an .xlsx file, flagging unsupported content like VBA macros or digital signatures that block writes. - Create and Edit: Build workbooks from JSON specs or apply cell edits via JSON edit files, with atomic temp-file publishing and post-write validation. - Coverage Manifests: Every operation emits a coverage.json manifest listing each item as preserved, transformed, unsupported, or skipped. - Use Case: You receive a sales workbook and need to update quarterly figures. Run inspect first to confirm no macros exist, apply edits via a JSON spec, and publish only after the manifest confirms full coverage. ## Quick Start Ask the agent to inspect the attached workbook.xlsx file and produce a coverage manifest before making any edits.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create an Excel .xlsx file from a JSON spec in Python?▼

Define a JSON spec with sheet titles and row arrays, then run the create command with the skill's CLI. The workbook is written atomically, validated against the spec, and published only when the coverage manifest shows coverage_ratio of 1.0.

How do I edit cells in an existing xlsx file with openpyxl?▼

Run inspect first to confirm the file has no unsupported parts, then supply a JSON edits file with set_cells entries listing sheet, coordinate, and value. The edit is verified cell-by-cell after writing before the output is published.

Can openpyxl handle Excel files with macros or VBA?▼

No. Files containing vbaProject.bin, OLE embeddings, digital signatures, or encryption are flagged as unsupported and block all write operations. The inspect command reports these items so you can decide how to proceed.

Does this xlsx workflow support legacy .xls files?▼

No, legacy .xls files are not supported. Only modern .xlsx files in OOXML format can be inspected, created, edited, or validated. Convert .xls files to .xlsx first using another tool.

Why does xlsx validation fail with a coverage error?▼

Validation fails when the coverage manifest contains unsupported items or the coverage_ratio is below 1.0. Common causes include macros, custom XML parts outside declared prefixes, or cell values that do not match the requested edits.

Related Skills

Explore More Data & Analytics Skills→
microclawmicroclaw
731

csv-tools

Inspect, filter, aggregate, and clean CSV and TSV data with Python.

Official
Basic
Canhada-LabsCanhada-Labs
2

analytics-reporter

Automates creation and review of business intelligence reports with data-source selection and dashboard design.

Official
Advanced
decocmsdecocms
396

xlsx

Extract cell data from Excel workbooks into tab-separated text.

Official
Basic
ClawLink-HQClawLink-HQ
117

google-sheets-spreadsheets

Automate spreadsheet creation, data reading/writing, and chart generation via the Google Sheets API.

Official
Intermediate