Excel (XLSX) Skill

Overview

This skill provides comprehensive capabilities for working with Excel spreadsheets programmatically using Python. It covers everything from basic file operations to advanced data analysis, formula management, chart creation, and formatting.

The primary library is openpyxl for full Excel file manipulation, supplemented by pandas for data analysis tasks.

Core Capabilities

1. File Operations

• Reading: Load .xlsx, .xlsm, and .csv files
• Writing: Create new Excel workbooks from scratch
• Editing: Modify existing workbooks while preserving formulas, formatting, and charts
• Converting: Transform between CSV, Excel, and other formats