📊 Excel2Insights Pro

Overview

小蔥技能7w4.net有完整的技能分類。

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