excel-automationlisted

# 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 ### xlwings vs openpyxl | Feature | xlwings | openpyxl | |---------|---------|----------| | Requires Excel | Yes | No | | Live interaction | Yes | No | | VBA execution | Yes | No | | Speed (large files) | Fast | Slow | | Server deployment | Limited | Easy | ### xlwings Fundamentals ```python import xlwings as xw # Connect to active Excel workbook wb = xw.Book.caller() # From Excel add-in wb = xw.books.active # Active workbook # Open specific file wb = xw.Book('path/to/file.xlsx') # Create new workbook wb = xw.Book() # Get sheet sheet = wb.sheets['Sheet1'] sheet = wb.sheets[0] ``` ### Working with Ranges #### Reading and Writing ```python # Single cell sheet['A1'].value = 'Hello' value = sheet['A1'].value # Range sheet['A1:C3'].value = [[1, 2, 3], [4, 5, 6], [7, 8, 9]] da