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
- Describe the Excel automation task you need
- Specify if you need live Excel interaction or file processing
- 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"