Does it support older .xls file formats?

Yes, it provides guidance on using engines like xlrd to ensure compatibility with older Excel file formats.

Does this skill require Microsoft Excel to be installed?

No, this skill uses Python libraries like pandas and openpyxl to process .xlsx files directly, meaning it can run in any environment without the Excel desktop application.

Can I create visual charts using this skill?

Absolutely. It includes patterns for generating various chart types like bar and pie charts using matplotlib based on your spreadsheet data.

Can I handle very large Excel files with this skill?

Yes, it includes performance optimization tips such as using chunksize for reading large datasets and usecols to minimize memory usage.

Is it possible to format cells and apply colors?

Yes, the skill demonstrates how to use openpyxl for advanced formatting, including conditional styling, bolding headers, and setting column widths.

Excel Analysis

Name: Excel Analysis
Author: Microck

byMicrock

•

데이터 과학 및 ML

Automates Excel spreadsheet manipulation, data analysis, and professional reporting using Python-based data science libraries.

This Claude Code skill provides specialized patterns for programmatically handling Excel files, enabling developers to automate complex spreadsheet tasks with ease. It covers a wide range of capabilities from basic data reading and cleaning to advanced operations like pivot table creation, multi-sheet merging, and conditional formatting. By leveraging industry-standard libraries like pandas and openpyxl, it allows users to transform raw tabular data into formatted, insightful reports and visualizations without manual intervention.

주요 기능

0181 GitHub stars

02Programmatic data cleaning and type conversion for messy spreadsheets

03Automated pivot table generation and multi-dimensional data aggregation

04Professional Excel formatting including conditional styles and auto-sizing

05Visual chart generation using matplotlib directly from workbook data

06Efficient multi-sheet processing and vertical/horizontal file merging

사용 사례

01Merging and cleaning disparate Excel data sources for data warehousing and ML pipelines

02Automating the generation of weekly financial reports with custom charts and formatting

03Building automated data validation tools to identify and fix errors in large workbooks

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microck/ordinary-claude-skills excel-analysis

For use in Claude.ai and ChatGPT

Download Skill