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

use std::env;
use std::path::PathBuf;
use json::{array, object};
use df_excel::{Head};
use df_excel::write::Excel;

fn main() {
    // if PathBuf::from(env!("CARGO_MANIFEST_DIR")) != env::current_dir().unwrap() {
    //     let mut dir = env::current_exe().unwrap();
    //     dir.pop();
    //     env::set_current_dir(dir).unwrap();
    // }
    // let root_path = env::current_dir().unwrap();
    //
    // let web_conf_path = root_path.join("file");
    // let web_conf_path = web_conf_path.join("name.xlsx");
    // let web_conf_path = web_conf_path.to_str().unwrap();

    let mut excel = Excel::new("/Users/carry/carryxdcoding/helpers/df-excel/examples/file/demo.xlsx");


    let heads = vec![
        Head::new("order_no", "订单", "", 0),
        Head::new("code", "编号", "", 0),
        Head::new("name", "名称", "", 0),
        Head::new("item", "项号", "", 0),
        Head::new("barcode", "条码", "", 0),
        Head::new("code", "货号", "", 0),
        Head::new("name", "描述", "", 0),
        Head::new("qty", "数量", "", 0),
        Head::new("price", "单价", "", 0),
        Head::new("subtotal", "合计", "", 0),
    ];

    let data = array![object! {"order_no":"123","code":"321","name":"订单123"},object! {"order_no":"123345","code":"321222","name":"订单123123123"}];

    excel.set_page(0, "name0", heads.clone(), data.clone());
    excel.set_page(1, "name1", heads.clone(), data);

    excel.save();
}