name: excel2insights-pro description: | Excel2Insights Pro — 交互式数据分析和可视化仪表板。 Automatically analyzes structured data (CSV/XLSX/TSV) and generates an interactive HTML dashboard with Plotly charts, data quality insights, and customizable branding.

Use when: 需要快速理解结构化数据的内容和模式、 生成交互式数据仪表板、数据质量分析、可视化报告、 品牌化数据展示、转换原始数据为可分享的洞察报告。

🎉 v1.1.0 Pro 核心功能： - 📊 Plotly 交互式图表（缩放/悬停/筛选） - 🎨 品牌化 HTML 仪表板（颜色/Logo/字体） - 🔍 自动数据质量分析 - 💡 关键洞察标签 - 🚀 一键完整分析管线

触发关键词：数据分析、数据可视化、CSV分析、Excel分析、 仪表板、交互式图表、数据洞察、数据质量、商业智能

适用范围：任意结构化数据文件（CSV/XLSX/TSV） 运行模式：纯本地，无网络请求 ❎ 外部依赖：Python标准库 + pandas + plotly

📊 Excel2Insights Pro

Overview

Excel2Insights Pro transforms structured data files into interactive, brandable HTML dashboards with a single command. It combines automated statistical analysis, data quality checks, and Plotly interactive visualizations into a polished, self-contained report.

What makes it Pro

Workflow

Quick Start (30 seconds)

# One-command: load → analyze → chart → dashboard
python3 scripts/auto-pipeline.py --file data.csv
# Opens: output/<dataset>_dashboard.html

Custom Brand Dashboard

# 1. Generate brand template
python3 scripts/dashboard-generator.py --init-brand brand.json

# 2. Edit brand.json (colors, logo, company name)

# 3. Run with branding
python3 scripts/auto-pipeline.py --file data.csv --brand-json brand.json

Custom Chart Selection

python3 scripts/auto-pipeline.py --file data.csv \
  --charts histogram,bar,heatmap,scatter,pairplot \
  --brand-json brand.json

Available Scripts

Script Details

excel-reader.py - --file PATH — Path to Excel/CSV/TSV file - --sheet NAME — Sheet name (XLSX only) - --encoding ENC — File encoding (default: utf-8)

data-analyzer.py - --file PATH — Path to data file - --output PATH — Output JSON path - --correlation — Include correlation matrix - --outliers — Enable outlier detection

chart-generator.py (Pro: Plotly interactive) - --file PATH — Path to data file - --charts TYPES — Comma-separated: histogram,boxplot,bar,line,pie,heatmap,scatter,pairplot - --columns COLS — Specific columns to visualize - --output DIR — Output directory

Generated charts are interactive HTML files with: - 🔍 Zoom & pan controls - 🖱️ Hover tooltips with values - 📏 Auto-scaling axes - 💾 SVG/PNG export (via Plotly toolbar)

dashboard-generator.py (Pro exclusive) - --analysis JSON — Analysis results JSON (required) - --charts DIR — Charts directory - --output PATH — Output dashboard HTML path - --brand-json PATH — Brand configuration file - --init-brand PATH — Generate brand template - --file DATA — Original data file (for stats)

auto-pipeline.py (Pro exclusive) - --file PATH — Data file (required) - --charts TYPES — Chart types (default: histogram,bar,heatmap,scatter) - --output DIR — Output directory - --format FORMAT — html / markdown / both - --brand-json PATH — Brand configuration

Brand Customization

小葱技能站7w4.net发现了升级插件。

Create a brand.json file to customize your dashboard:

{
  "company_name": "Your Company",
  "logo_url": "",
  "primary_color": "#1a73e8",
  "secondary_color": "#34a853",
  "accent_color": "#ea4335",
  "font_family": "'Inter', sans-serif",
  "show_footer": true,
  "footer_text": "Generated by Excel2Insights Pro | Your Company"
}

Generate a template: python3 scripts/dashboard-generator.py --init-brand brand.json

Examples

Example 1: Quick Dashboard

python3 scripts/auto-pipeline.py --file sales_data.csv
# Output: output/sales_data_dashboard.html
# → Interactive dashboard with histogram, bar, and correlation charts

Example 2: Full Analysis with Branding

python3 scripts/auto-pipeline.py --file survey_2024.xlsx \
  --charts histogram,bar,boxplot,heatmap,scatter \
  --brand-json brand.json
# Output: output/survey_2024_dashboard.html
# → Branded dashboard with 5 chart types

Example 3: Manual Step-by-Step

# Step 1: Analyze
python3 scripts/data-analyzer.py --file data.csv \
  --output analysis.json --correlation --outliers

# Step 2: Generate charts
python3 scripts/chart-generator.py --file data.csv \
  --charts histogram,bar,heatmap,scatter --output charts/

# Step 3: Build dashboard
python3 scripts/dashboard-generator.py \
  --file data.csv --analysis analysis.json \
  --charts charts/ --output dashboard.html \
  --brand-json brand.json

Output Format

The dashboard is a self-contained HTML file that includes:

<!-- Summary Cards → overview stats -->
<!-- Data Quality → missing values, column profile -->
<!-- Interactive Charts → Plotly with zoom/hover/pan -->
<!-- Key Insights → tagged findings with severity -->

Open it directly in any browser — no server required.

Legal

Disclaimer

This tool provides data analysis and visualization. It does not make business decisions. Users are responsible for interpreting results and making informed decisions.

License

MIT License. See LICENSE file for details.

Security & Constraints

Declared Capabilities

Explicitly Denied

• ❌ No network access (HTTP, socket, API calls)
• ❌ No arbitrary code execution via exec()/eval()
• ❌ No dynamic imports from external sources
• ❌ No system commands via subprocess/shell
• ❌ No telemetry, analytics, or usage reporting
• ❌ No external script fetching
• ❌ No auto-update mechanisms

Data Privacy

• All processing is local — no data leaves the machine
• Output files are saved to the working directory
• No user data is collected or transmitted

这个工具能把 Excel 和 CSV 文件自动变成带交互图表的可视化报告，操作简单、功能丰富、图表美观。品牌定制功能让报告看起来很专业，数据分析也很全面。但存在两个问题：完整流程有个脚本缺失，会导致一键生成失败；部分示例文档描述与实际输出不符，可能让人摸不着头脑。总体不错，但稳定性和文档准确性还需改进。