excel-automation

Real-time Excel automation with live workbook control, VBA execution, and dashboard updates. 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. Example prompts: - 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 - 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 - "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" - Disable Screen Updating : For batch operations - Use Arrays : Read/write entire ranges, not cell-by-cell - Manual...