excel-inspector
Excel Inspector Skill
Automated Excel file structure analysis for AI code generation
Overview
This skill analyzes Excel files and outputs structured metadata (JSON) to help AI understand:
- Sheet structure and table definitions
- Column names and data types
- VBA code modules
- Sample data and statistics
When to Use
- Before writing VBA code: understand existing modules and procedures
- Before Python Excel automation: know sheet/column structure and data types
- When analyzing Excel file structure: get complete metadata in JSON format
- When modifying existing Excel macros: extract current VBA code to a file
- When debugging Excel data issues: analyze data types and sample values
More from rukkha1024/elderly-balance-assessment
excel-vba-modifier
Safely modify Excel VBA code using xlwings. Checks Trust Center permissions, reads/writes modules, and runs test macros. Always creates backups before modifications.
21excel-backup-manager
Create, manage, and restore Excel file backups with automatic timestamps. Use before modifying Excel files to ensure data safety and enable rollback if needed.
13playwright-excel
Integrate Excel (.xlsx) data into Playwright codegen scripts by replacing hardcoded values with config-driven lookups, loading data with polars, and validating every step with Playwright MCP (start MCP from the repo if not running). Use for Playwright automation updates that require Excel-backed data, config.yaml centralization, or MCP validation/reporting.
9excel-na-utils
Helper functions for NA/missing value handling in Excel data. Provides Python and VBA implementations following CLAUDE.md NA handling guidelines.
8