excel-automation

Official

Automate Excel tasks with xlwings

Authorclaude-office-skills
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This skill automates complex Excel tasks, including live interaction, VBA execution, and dynamic report generation, reducing manual effort and errors.

Core Features & Use Cases

  • Live Excel Interaction: Control running Excel instances for real-time updates and dashboard automation.
  • VBA Macro Execution: Run existing VBA macros directly from Python.
  • Dynamic Report Generation: Automate the creation and export of reports, including PDF conversions.
  • Use Case: Automate the monthly generation of sales reports by pulling data, updating charts, and exporting the final report as a PDF.

Quick Start

Use the excel-automation skill to update the live dashboard in the active Excel workbook with new sales data.

Dependency Matrix

Required Modules

xlwingspandasmatplotlib

Components

scriptsreferences

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: excel-automation
Download link: https://github.com/claude-office-skills/skills/archive/main.zip#excel-automation

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.