xlsx-handlebars 0.1.3

A Rust library for processing XLSX files with Handlebars templates, supporting WASM, Node.js, Deno, and browsers
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101

use base64::{engine::general_purpose, Engine};
/**
 * Rust native example for xlsx-handlebars
 * 
 * 运行命令: cargo run --example rust_example
 */

use xlsx_handlebars::template;
use serde_json::json;
use std::fs;

fn main() -> Result<(), Box<dyn std::error::Error>> {
    println!("🦀 Rust Native XLSX Handlebars 处理示例\n");
    
    // 检查模板文件是否存在
    let template_path = "./examples/template.xlsx";
    if !std::path::Path::new(template_path).exists() {
        println!("⚠️  模板文件不存在: {}", template_path);
        return Ok(());
    }
    
    // 读取模板文件
    println!("📖 读取模板文件...");
    let template_bytes = fs::read(template_path)?;
    
    // 准备数据
    let data = json!({
        "employee": {
            "name": "陈小华",
            "department": "产品部",
            "position": "产品经理",
            "hire_date": "2024-02-20",
            "has_bonus": true,
            "bonus_amount": 12000,
            "email": "chenxiaohua@company.com"
        },
        "company": {
            "name": "创新科技有限公司",
            "address": "上海市浦东新区张江高科技园区",
            "industry": "人工智能"
        },
        "projects": [
            {
                "name": "AI助手平台",
                "description": "智能对话系统产品设计",
                "status": "已上线",
                "duration": "3个月",
                "team_size": 8
            },
            {
                "name": "数据分析工具",
                "description": "用户行为分析平台",
                "status": "开发中",
                "duration": "2个月",
                "team_size": 5
            },
            {
                "name": "移动应用重构",
                "description": "用户体验优化项目",
                "status": "规划中",
                "duration": "4个月",
                "team_size": 12
            }
        ],
        "skills": ["产品设计", "用户研究", "数据分析", "项目管理", "敏捷开发"],
        "achievements": [
            "产品用户量增长200%",
            "用户满意度提升至4.8/5.0",
            "获得年度最佳产品奖",
            "主导3次成功的产品迭代"
        ],
        "performance": {
            "rating": "优秀",
            "score": 92,
            "goals_achieved": 8,
            "total_goals": 10
        },
        "metadata": {
            "report_date": "2025/6/26",
            "quarter": "2024 Q1",
            "version": "v1.0"
        },
        "image": {
            "base64": general_purpose::STANDARD.encode(&fs::read("./examples/image.png")?)
        }
    });
    
    // 渲染模板
    println!("\n🎨 渲染模板...");
    let result_bytes = template::render_handlebars(template_bytes, &data)?;
    
    // 保存结果
    let output_path = "./examples/output_rust.xlsx";
    fs::write(output_path, result_bytes)?;
    
    println!("✅ 处理完成！结果已保存到: {}", output_path);
    
    println!("\n🎉 Rust 示例执行完成！");
    
    Ok(())
}