Developer Tools

Excel Data Analyzer

Excel 数据分析

Automated Excel data cleaning, analysis and visualization. Supports energy industry data report generation.

Excel数据分析可视化报表自动化
Install Command
npx openclaw skills install excel-analyzer
Version
1.0.0
Author
shuzhihui
Updated
Sat Apr 11 2026 00:00:00 GMT+0000 (Coordinated Universal Time)

Features

  • Multi-sheet Excel file parsing
  • Data cleaning and standardization
  • Automated statistical analysis
  • Chart and pivot table generation
  • Energy sector data templates
  • Use Cases

  • **Finance Team**: Automate monthly financial report generation
  • **Operations**: Analyze production and consumption data
  • **Sales**: Generate customer performance dashboards
  • Installation

    npx openclaw skills install excel-analyzer

    Usage Examples

    # Analyze Excel file

    excel-analyzer analyze --input data.xlsx --summary

    # Generate analysis report

    excel-analyzer report --input quarterly-data.xlsx --template financial

    # Create visualization

    excel-analyzer chart --input production.xlsx --type line --output chart.png

    # Energy sector specific

    excel-analyzer energy --input energy-consumption.xlsx --metrics carbon,output

    Supported Analysis Types

    | Type | Description |

    |------|-------------|

    | Descriptive | Mean, median, std, percentiles |

    | Trend | Time-series analysis and forecasting |

    | Comparative | Cross-period, cross-region comparison |

    | Correlation | Variable relationship analysis |