免责声明

本工具仅供学习和研究参考，不构成任何投资建议。投资有风险，入市需谨慎。 本工具为数据分析辅助工具，提供的分析结果仅供参考， 不构成任何投资建议，不构成投资建议，不构成任何法律建议，不构成法律建议。 用户应结合实际情况自行判断并承担相关责任。

📊 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()
• ❌ 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