officecli-xlsx

Automate Excel workbook creation, editing, and analysis via OfficeCLI.

1.3k|179|Updated Feb 3, 2025
One-click install
npx skills add https://github.com/Team-Commonly/commonly --skill officecli-xlsx-team-commonly
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: officecli-xlsx
Source: https://github.com/Team-Commonly/commonly/tree/main/backend/commonly-bundled-skills/officecli/skills/officecli-xlsx
Command: npx skills add https://github.com/Team-Commonly/commonly --skill officecli-xlsx-team-commonly

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

The OfficeCLI XLSX Skill enables automated creation, editing, and analysis of Excel workbooks from plain-language prompts, replacing manual spreadsheet setup with repeatable, scriptable workflows.

Core Features & Use Cases

  • Automates workbook creation, edits, and formulas on .xlsx files.
  • Supports charts, pivots, data imports/exports, and template preservation.
  • Use Case: Build a repeatable monthly revenue model by generating sheets, applying formulas, and exporting results without manual Excel interactions.

Quick Start

Install OfficeCLI, create a new workbook, set a header in Sheet1, add a simple SUM formula, and save the workbook.

Frequently Asked Questions about officecli-xlsx

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

FAQPage Schema
How do I automate Excel workbook creation and formula application?

Automate Excel workbook creation by using OfficeCLI to generate sheets, apply formulas, and save .xlsx files through scriptable, repeatable workflows triggered from plain-language prompts.

Can I build financial models in .xlsx files without manual Excel interactions?

Yes, you can build financial models in .xlsx files without manual interactions by programmatically generating sheets and applying formulas to create repeatable revenue models or trackers.

Does OfficeCLI support generating charts and pivots in Excel workbooks?

Yes, OfficeCLI supports generating charts and pivots within Excel workbooks, alongside data imports and exports, while preserving existing templates during automated edits.

What is the best way to create repeatable monthly revenue models in Excel?

The best way to create repeatable monthly revenue models is to automate workbook generation, apply formulas, and export results programmatically, replacing manual spreadsheet setup with deterministic command execution.

How do I ensure proper shell quoting and formatting when automating Excel workflows?

To ensure proper shell quoting and formatting when automating Excel workflows, use a Skill that enforces deterministic command execution and explicit formatting rules for robust .xlsx workbook generation.