Excel Data Processing Skill

Capabilities

1. Data Reading: Extract worksheets and cell data from Excel files
2. Data Analysis: Calculate statistical indicators (sum, average, maximum/minimum value, etc.)
3. Data Filtering: Filter data based on conditions
4. Report Generation: Perform summary analysis on data and generate readable reports

Usage Process

1. User provides the xlsx file path
2. Use the

   read_excel

   script to read the file content
3. Analyze the data structure and content
4. For detailed analysis, use the

   analyze_excel

   script

Output Format

## File Information
- File Name: xxx.xlsx
- Number of Worksheets: X
- Total Rows: X

## Data Overview
[Basic information and column structure of each worksheet]

## Data Analysis
[Specific analysis based on user requirements]

## Key Findings
- [Key Finding 1]
- [Key Finding 2]

Notes

• Large files may require paginated reading
• Pay attention to correct parsing of date formats
• Merged cells require special handling