xlsx
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.)
More from autumnsgrove/claudeskills
d3js-visualization
Professional data visualization creation using D3.js with support for interactive charts, custom visualizations, animations, and responsive design. Use for: (1) Creating custom interactive charts, (2) Building dashboards, (3) Network/graph visualizations, (4) Geographic data mapping, (5) Time series analysis, (6) Real-time data visualization, (7) Complex multi-dimensional data displays
21pptx
Professional PowerPoint presentation creation, editing, and automation with support for layouts, templates, charts, images, and formatting. Use when working with .pptx files for: (1) Creating presentations from scratch, (2) Editing existing presentations, (3) Applying templates and themes, (4) Adding charts and visualizations, (5) Bulk slide generation, (6) Presentation automation
15brand-guidelines
Professional brand consistency enforcement and corporate identity management with support for color palettes, typography, logo usage, tone of voice, and multi-channel brand application. Use for: (1) Creating brand style guides, (2) Enforcing brand consistency across documents, (3) Logo usage validation, (4) Typography standards, (5) Color palette management, (6) Brand voice guidelines
15webapp-testing
Professional web application testing and automation using Playwright with support for multiple browsers, mobile emulation, screenshot capture, network interception, and comprehensive test assertions. Use for: (1) E2E testing across browsers, (2) UI automation, (3) Form testing and validation, (4) Visual regression testing, (5) API mocking and interception, (6) Mobile responsive testing
14error-detective
Systematic debugging and error resolution using the TRACE framework (Trace, Read, Analyze, Check, Execute). Use when debugging errors, analyzing stack traces, investigating failures, root cause analysis, or troubleshooting production issues.
14sql-expert
Expert SQL query writing, optimization, and database schema design with support for PostgreSQL, MySQL, SQLite, and SQL Server. Use when working with databases for: (1) Writing complex SQL queries with joins, subqueries, and window functions, (2) Optimizing slow queries and analyzing execution plans, (3) Designing database schemas with proper normalization, (4) Creating indexes and improving query performance, (5) Writing migrations and handling schema changes, (6) Debugging SQL errors and query issues
13