Report Beautifier

SKILL.md

# Report Beautifier

**Slug:** `report-beautifier`

> Upload Word / Excel / PDF reports → AI analyzes data structure and content → Outputs professional presentations (PPTX / PDF)

---

## Billing

**$0.01 USDT per call** — billed via SkillPay at [https://skillpay.me/report-beautifier](https://skillpay.me/report-beautifier)

A small fee is charged each time you beautify a document. No monthly subscription required.

> **Privacy Note:** Your Feishu User ID (Open ID) may be transmitted to skillpay.me for billing purposes only.
> **Privacy Note:** This skill does not store, log, or share any of your document content. All processing is ephemeral.

---

## Required Environment Variables

| Variable | Description |
|----------|-------------|
| `SKILL_BILLING_API_KEY` | SkillPay API key for billing. Leave empty or set to `dev` for dev mode (balance=999). |
| `SKILL_BILLING_SKILL_ID` | Skill ID on SkillPay. Defaults to `report-beautifier`. |

---

## Tiered Features

| Feature | FREE | PRO |
|---------|------|-----|
| **Price** | $0 (free) | $0.01 / call |
| **Monthly uses** | 3 | Unlimited |
| **Input formats** | Word | Word, Excel, PDF |
| **Templates** | 1 | All 15 templates |
| **Output formats** | PPTX preview | PPTX, PDF, PNG |
| **Download** | No | Yes |
| **Charts** | Basic | Advanced |
| **Scene detection** | No | Yes |
| **Speech script** | No | Yes |

---

## Quick Start

```python
from scripts.beautifier import beautify_report

result = beautify_report(
    file_path="/path/to/report.xlsx",
    api_key="PRO-your-api-key",
    template="business_blue",
    output_format="pptx"
)

if result["success"]:
    print(f"Output: {result['output_path']}")
else:
    print(f"Error: {result['error']}")
```

---

## Advanced Usage

```python
from scripts.beautifier import ReportBeautifier, BeautifierConfig

config = BeautifierConfig(
    template_id="tech_purple",
    output_format="pptx",
    include_charts=True,
    quality="high"
)

beautifier = ReportBeautifier(api_key="PRO-your-key", config=config)
result = beautifier.beautify_file("/path/to/report.xlsx")
print(result)
```

---

## Supported Formats

| Format | Extensions | Notes |
|--------|------------|-------|
| Word | `.docx`, `.doc` | Extracts titles, paragraphs, tables |
| Excel | `.xlsx`, `.xls` | Multi-sheet support, smart header detection |
| PDF | `.pdf` | Text extraction, simple table detection |
| CSV | `.csv` | Auto-parsing with header inference |

---

## Available Templates (15)

**Business:** `business_blue`, `finance_gray`, `government_red`  
**Education/Professional:** `teaching_green`, `tech_purple`, `ocean_blue`  
**Vibrant:** `vibrant_orange`, `rose_pink`, `vibrant_purple`  
**Minimal:** `minimal_white`, `night_dark`, `fresh_cyan`  
**Premium:** `classic_gold`, `forest_green`, `deep_sea_blue`

---

## Output Formats

- **PPTX** — PowerPoint presentation (default)
- **PDF** — PDF document
- **PNG** — Single chart image

---

## Scene Detection

Automatically detects report type and applies matching style:

- `financial` — Financial reports
- `sales` — Sales reports
- `report` — Work reports / presentations
- `bidding` — Bid proposals
- `teaching` — Teaching materials
- `general` — General documents

---

## Error Handling

```python
try:
    result = beautify_report(file_path, api_key)
    if not result["success"]:
        print(f"Failed: {result['error']}")
except Exception as e:
    print(f"System error: {e}")
```

---

## Dependencies

```
python-docx>=1.1.0
openpyxl>=3.1.2
PyPDF2>=3.0.0
python-pptx>=1.0.1
matplotlib>=3.7.0
plotly>=5.18.0
requests>=2.31.0
Pillow>=10.0.0
kaleido>=0.2.1
```

---

> For paid use, visit [https://skillpay.me/report-beautifier](https://skillpay.me/report-beautifier)