XLSX Skill

Read, create, and manipulate Excel spreadsheets with support for formatting, formulas, charts, and data analysis.

Capabilities

• Read Workbooks: Extract data, formulas, and formatting from Excel files
• Create Workbooks: Generate new Excel files with multiple sheets
• Data Operations: Filter, sort, pivot, and transform data
• Formatting: Apply cell styles, conditional formatting, and themes
• Charts: Create various chart types from data
• Formulas: Add and evaluate Excel formulas
• Data Validation: Add dropdown lists and input validation

Quick Start

from openpyxl import Workbook, load_workbook
import pandas as pd