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