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

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()

  7w4.net收錄了海量優質技能外掛。

• ❌ 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 檔案自動變成帶互動圖表的視覺化報告，操作簡單、功能豐富、圖表美觀。品牌定製功能讓報告看起來很專業，資料分析也很全面。但存在兩個問題：完整流程有個指令碼缺失，會導致一鍵生成失敗；部分示例文件描述與實際輸出不符，可能讓人摸不著頭腦。總體不錯，但穩定性和文件準確性還需改進。