xlsxlisted

# 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 ### 2. Data Management - **Cell Operations**: Read, write, and modify individual cells or ranges - **Formulas**: Create and manage Excel formulas (SUM, VLOOKUP, INDEX/MATCH, etc.) - **Data Validation**: Set dropdown lists, numeric ranges, date constraints - **Named Ranges**: Define and use named cell ranges for easier formula management ### 3. Formatting - **Cell Styling**: Fonts, colors, borders, alignment, number formats - **Conditional Formatting**: Apply rules-based formatting - **Row/Column Sizing**: Set widths, heights, auto-fit - **Merge Cells**: Combine cells for headers and labels ### 4. Charts & Visualizations - **Chart Types**: Line, bar, column, pie, scatter, area, combo charts - **Chart Customization**: Titles, legends, data labels, colors - **Multiple Series**: Multi