officecli-xlsx

Create, edit, and validate Excel workbooks using the OfficeCLI command-line tool.

1|Updated Jul 22, 2026
One-click install
npx skills add https://github.com/IceHeartGitH/Hermes-Agent-Android-Termux --skill officecli-xlsx-iceheartgith
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: officecli-xlsx
Source: https://github.com/IceHeartGitH/Hermes-Agent-Android-Termux/tree/main/custom-skills/productivity/officecli-xlsx
Command: npx skills add https://github.com/IceHeartGitH/Hermes-Agent-Android-Termux --skill officecli-xlsx-iceheartgith

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Building or editing .xlsx spreadsheets by hand is slow and error-prone, especially for financial models, dashboards, and trackers that need formulas, charts, and consistent formatting. This Skill gives an AI agent a disciplined, command-line workflow for producing professional workbooks with zero formula errors. ## Core Features & Use Cases - Workbook creation and editing: Set cells, formulas, named ranges, charts, pivot tables, conditional formatting, and data validation through OfficeCLI commands. - Reading and analysis: Inspect existing workbooks with outline, text, annotated, and query views, plus round-trip dumps for cloning templates. - CSV/TSV bulk import: Load large datasets into sheets in one call or via chunked batch operations. - Use Case: Build a 3-statement financial model with industry-standard color coding, guarded formulas, print-ready page layout, and a full QA pass that catches #REF! errors, stale cached values, and placeholder tokens before delivery. ## Quick Start Use the officecli-xlsx skill to create a revenue tracker spreadsheet with three months of data, a SUM total formula, currency formatting, and validated output.

Frequently Asked Questions about officecli-xlsx

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

FAQPage Schema
How do I create an Excel spreadsheet from the command line?▼

Use officecli create to make the file, then set cells and formulas with officecli set, add column widths and number formats, and finish with officecli validate. The skill provides a quick-start pattern covering open, edit, format, close, and validate steps.

How to import CSV data into an xlsx file?▼

Run officecli import with the target file, sheet path, and --file data.csv --header to load the CSV in one call with AutoFilter and a frozen header row. For custom type coercion, use the Python plus batch fallback recipe that chunks value-set operations.

Does officecli work on Android with Termux?▼

The Hermes adaptation does not auto-install OfficeCLI and requires verifying binary compatibility first with command -v officecli and officecli --version. If the binary is missing or incompatible, the skill falls back to existing Hermes productivity skills instead.

Why do cross-sheet formulas break in shell commands?▼

Shells mangle the exclamation mark in references like Sheet1!A1 into a backslash-bang, silently breaking the formula. The fix is writing them through a batch heredoc with a single-quoted delimiter, then verifying with officecli get that no backslash remains.

What are the limitations of officecli validate?▼

Validate catches schema errors but not design errors, so a workbook can pass with wrong numbers. The skill mandates a QA cycle including error-cell queries, cached-value spot checks, and an HTML preview pass to catch visual and logic problems.