Struct df_excel::write::Excel

source ·

pub struct Excel { /* private fields */ }

Implementations§

source §

impl Excel

source

pub fn new(filepath: &str) -> Self

Examples found in repository ?

examples/write.rs (line 19)

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();
}

source

pub fn set_page( &mut self, page: usize, nane: &str, heads: Vec<Head>, data: JsonValue ) -> &mut Self

Examples found in repository ?

examples/write.rs (line 37)

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();
}

source

pub fn save(&mut self)

Examples found in repository ?

examples/write.rs (line 40)

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();
}