officecli-xlsx

Automate reading, editing, and validating Excel .xlsx files via officecli CLI.

575|90|Updated Feb 5, 2026
One-click install
npx skills add https://github.com/oneclaw/oneclaw --skill officecli-xlsx-oneclaw
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: officecli-xlsx
Source: https://github.com/oneclaw/oneclaw/tree/main/builtin-skills/officecli-xlsx
Command: npx skills add https://github.com/oneclaw/oneclaw --skill officecli-xlsx-oneclaw

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires officecli.

What problem does it solve?

This Skill removes the tedium and fragility of manually editing and validating Excel spreadsheets by using the officecli command-line tool with safe, repeatable batch workflows.

Core Features & Use Cases

  • Read and validate existing spreadsheets: Inspect cell/range contents, formulas, charts, tables, pivots, and data issues to catch broken references early.
  • Create and modify .xlsx files reliably: Build or update workbooks (including formulas, formatting, number formats, charts, pivots, validation, and templates).
  • Bulk edits via JSON batch ops: Perform deterministic bulk changes through officecli batch using a UTF-8 JSON file (avoids shell/encoding pitfalls, especially on Windows PowerShell).
  • CSV/TSV to Excel: Import tabular data into sheets as Excel-ready tables and structures.

Quick Start

Use the officecli-xlsx skill to update the attached spreadsheet file by following the Skill’s rules and applying your requested changes to the .xlsx cells, ranges, charts, or tables.

Frequently Asked Questions about officecli-xlsx

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

FAQPage Schema
How do I automate bulk edits to Excel xlsx spreadsheets without writing scripts?

You can automate bulk edits to Excel xlsx spreadsheets by applying deterministic JSON batch operations through the officecli CLI, enforcing a zero-interpreted-script workflow that safely updates workbook cells, formulas, and formatting.

Can I import CSV or TSV files into an Excel workbook and format them as tables?

Yes, you can import CSV or TSV tabular data into Excel xlsx workbooks using the officecli CLI, which converts the raw text data into structured Excel-ready tables within your spreadsheet.

How do I validate formulas and check for broken references in an existing xlsx file?

You can validate formulas and check for broken references in an xlsx file by using the officecli CLI to inspect cell contents, data issues, and charts, ensuring your financial models and dashboards remain accurate.

What is the best way to generate Excel dashboards and charts from the command line?

The best way to generate Excel dashboards and charts from the command line is using the officecli CLI to build or update workbooks with formula-driven structures, applying formatting and pivot tables via JSON batch inputs.

Do I need the officecli CLI installed to use this spreadsheet automation Skill?

Yes, you must install the officecli CLI dependency to use this Skill, as it acts as the core engine for reading, editing, and validating xlsx spreadsheets through JSON-based batch operations.

Why do my Excel bulk edits fail with encoding issues on Windows PowerShell?

Excel bulk edits often fail on Windows PowerShell due to shell encoding pitfalls; using a UTF-8 JSON file for batch operations with the officecli CLI avoids these encoding issues and ensures deterministic execution.