skills.rest
sbroenne
sbroenneCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

excel-cli

Automates Microsoft Excel tasks via command-line interface on Windows.

427|61|Updated Oct 19, 2025
Search Tags:#automation#cli#excel#scripting#dax#power query
One-click install
npx skills add https://github.com/sbroenne/mcp-server-excel --skill excel-cli
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-cli
Source: https://github.com/sbroenne/mcp-server-excel/tree/main/skills/excel-cli
Command: npx skills add https://github.com/sbroenne/mcp-server-excel --skill excel-cli

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill allows you to automate Microsoft Excel tasks directly from the command line, making it ideal for scripting, CI/CD pipelines, and integration with AI coding assistants.

Core Features & Use Cases

  • Comprehensive Automation: Automate Power Query, DAX measures, VBA macros, PivotTables, Charts, formatting, and data transformations.
  • Scriptable Workflows: Integrate Excel operations into batch scripts, PowerShell pipelines, or automated testing frameworks.
  • Use Case: You need to generate a daily sales report. This Skill can be used in a script to open an Excel file, refresh a Power Query, update a PivotTable, and save the workbook, all without manual intervention.

Quick Start

Use the excel-cli skill to open the workbook 'C:\Data\Report.xlsx' and save it.

Frequently Asked Questions about excel-cli

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

FAQPage Schema
How do I automate Excel tasks from the command line?▼

You can automate Excel tasks from the command line by using a CLI tool to script operations like refreshing Power Query, updating PivotTables, and saving workbooks without manual intervention.

Can I run Excel VBA macros and DAX measures in a CI/CD pipeline?▼

Yes, you can run Excel VBA macros and DAX measures in a CI/CD pipeline by integrating command-line automation scripts that execute workbook operations during automated builds.

Does command-line Excel automation work on Linux or macOS?▼

Command-line Excel automation requires Windows and Microsoft Excel 2016 or later, as it directly controls the local desktop application and does not support Linux or macOS environments.

What is the best way to script Power Query refreshes for daily reports?▼

The best way to script Power Query refreshes for daily reports is using command-line automation to open the workbook, trigger the data refresh, update PivotTables, and save the file automatically.

Are there limitations when controlling Excel via scripting compared to the GUI?▼

Limitations when controlling Excel via scripting include the strict dependency on a Windows environment with a local Excel 2016+ installation, restricting its use in headless server or cloud-only architectures.

Related Skills

Explore More Software Engineering Skills→
dachentdachent
18

xlsx-win

Automate Microsoft Excel COM operations on Windows using JSON job contracts.

Community
Advanced
sammyTIsammyTI

xlsx-author

Create Excel workbooks with openpyxl in headless Python environments.

Community
Intermediate
moshi-azzmoshi-azz
2

experto-excel

Guide Excel users through formulas, VBA macros, and data analysis.

Community
Advanced
kk580kkkk580kk
1

xiaoyi-xlsx

Automate Excel spreadsheet operations for data manipulation, analysis, and visualization.

Community
Advanced