XLSX Creation, Editing, and Analysis

Overview

This skill enables Cline to create, edit, and analyze Excel spreadsheets using Python libraries. Different workflows are available depending on the task: pandas for data analysis and bulk operations, openpyxl for formulas, formatting, and Excel-specific features.

When to Use This Skill

• Creating new spreadsheets with formulas, charts, and formatting
• Reading or analyzing data from existing Excel files
• Modifying spreadsheets while preserving formulas and formatting
• Building financial models with proper conventions
• Data transformation and visualization in spreadsheet format
• Converting data between formats (CSV, TSV → XLSX)

Workflow Decision Tree

Reading/Analyzing Data

Use pandas for quick data analysis or openpyxl with data_only=True for calculated values.