officecli-xlsx

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

Updated Jul 10, 2026
One-click install
npx skills add https://github.com/Grong/openhub-client --skill officecli-xlsx-grong
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: officecli-xlsx
Source: https://github.com/Grong/openhub-client/tree/main/crates/backend/openhub-app/assets/builtin-skills/officecli-xlsx
Command: npx skills add https://github.com/Grong/openhub-client --skill officecli-xlsx-grong

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Building or editing .xlsx files programmatically often produces broken formulas, clipped columns, stale cached values, and unprofessional formatting. This Skill provides a disciplined workflow for producing correct, well-formatted Excel workbooks through the officecli CLI, with built-in QA and visual verification steps. ## Core Features & Use Cases - Workbook creation and editing: Set cells, formulas, named ranges, charts, pivot tables, conditional formatting, and data validation via officecli commands. - CSV/TSV bulk import: Load large datasets into sheets with the native import command or Python-generated batch chunks. - Financial model standards: Enforce industry color coding, number formats, and assumption documentation for budgets, forecasts, and valuation models. - Mandatory QA cycle: Query for formula errors, inspect cached values, and audit rendered HTML previews before delivery. - Use Case: Build a 3-statement financial model with cross-sheet formulas, charts, and print-ready layout, then verify zero formula errors and no clipped columns before sending it to stakeholders. ## Quick Start Ask the AI to create an Excel workbook with monthly revenue data, a SUM total formula, currency formatting, and proper column widths using the officecli-xlsx skill.

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 file from the command line?

Use officecli create to make the file, then officecli open to enter resident mode and set cells, formulas, and formatting with officecli set commands. Finish with officecli close to write to disk and officecli validate to confirm the file has no errors.

How do I import a CSV file into an xlsx workbook?

Run officecli import with the target sheet, --file pointing to your CSV, and --header to add AutoFilter and freeze the header row. For custom type coercion or formula injection, generate batch JSON chunks with a Python script and pipe them into officecli batch.

Why do cross-sheet formulas break when written from the shell?

Shells mangle the exclamation mark in references like Sheet1!A1 into a backslash-escaped form, silently breaking the formula. Write cross-sheet formulas through a batch heredoc with a single-quoted delimiter, then verify with officecli get that the formula shows a plain exclamation mark.

Does officecli support charts and pivot tables in xlsx files?

Yes, officecli add supports charts with over 20 types including waterfall and treemap, plus pivot tables, slicers, and sparklines. Chart anchors and series are immutable after creation, so resizing requires removing and re-adding the chart.

Why does my delivered workbook show wrong values in formula cells?

Newly written formulas ship without cached values, and downstream formulas can cache stale results from upstream cells. Re-touch downstream cells with officecli set after multi-formula builds, then spot-check cachedValue fields with officecli get before delivery.