Skills

excel-automation

Installation
Summary

Real-time Excel automation with live workbook control, VBA execution, and dashboard updates.

  • Connects to active Excel instances for live interaction, unlike file-only libraries; supports reading, writing, and formatting ranges with array operations for performance
  • Executes VBA macros, creates user-defined functions (UDFs), and manages charts, tables, and pictures programmatically
  • Includes application-level controls (screen updating, calculation mode) and batch processing patterns for multi-file workflows
  • Requires Excel installed locally; best suited for desktop automation, dashboards, and report generation rather than server-side processing
SKILL.md

Excel Automation Skill

Overview

This skill enables advanced Excel automation using xlwings - a library that can interact with live Excel instances. Unlike openpyxl (file-only), xlwings can control Excel in real-time, execute VBA, update dashboards, and automate complex workflows.

How to Use

  1. Describe the Excel automation task you need
  2. Specify if you need live Excel interaction or file processing
  3. I'll generate xlwings code and execute it

Example prompts:

  • "Update this live Excel dashboard with new data"
  • "Run this VBA macro and get the results"
  • "Create an Excel add-in for data validation"
  • "Automate monthly report generation with live charts"

Domain Knowledge

Related skills

More from claude-office-skills/skills

Installs
7.4K
Repository
claude-office-s…s/skills
GitHub Stars
122
First Seen
Mar 9, 2026
Security Audits
Gen Agent Trust HubWarn
SocketPass
SnykPass