Automates Excel spreadsheet analysis, data cleaning, and reporting using Python's most powerful data libraries.
This skill empowers Claude to perform advanced spreadsheet operations, transforming raw .xlsx and .csv files into actionable insights. It provides standardized patterns for reading multiple sheets, generating complex pivot tables, creating professional charts with Matplotlib, and applying conditional formatting with openpyxl. Whether you're merging disparate datasets or building automated reporting pipelines, this skill streamlines the entire data engineering workflow within the Claude Code environment by leveraging optimized pandas and openpyxl implementations.
主要功能
01Advanced Excel styling including conditional formatting and auto-adjusting widths
02Performance-optimized reading configurations for large-scale data files
030 GitHub stars
04Automated data cleaning and type conversion for messy spreadsheets
05Programmatic pivot table and chart generation for rapid reporting
06Multi-sheet processing and vertical/horizontal dataset merging
使用场景
01Automating weekly sales reports with integrated pivot tables and visual charts
02Merging and cleaning customer data harvested from multiple disparate workbooks
03Applying programmatic conditional formatting to highlight key business metrics
