pub struct Head {
pub field: String,
pub title: String,
pub note: String,
pub width: i32,
}Fields§
§field: String§title: String§note: String§width: i32Implementations§
source§impl Head
impl Head
sourcepub fn new(field: &str, title: &str, note: &str, width: i32) -> Self
pub fn new(field: &str, title: &str, note: &str, width: i32) -> Self
Examples found in repository?
examples/read.rs (line 16)
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
fn main() {
// let path = format!("/Users/xiaduan/carrycoding/edi/edi-service/public/file/xlsx/a8df8a29b622d4017486f12df7586d3c6d662d80.xlsx");
let path = format!("{}/examples/file/0450762145test.xlsx", env!("CARGO_MANIFEST_DIR"));
// let path = format!("{}/examples/file/a8df8a29b622d4017486f12df7586d3c6d662d80.xlsx", env!("CARGO_MANIFEST_DIR"));
// let heads = vec![
// Head::new("order_no", "订单", "", 0),
// Head::new("code", "编号", "", 0),
// Head::new("name", "名称", "", 0),
// ];
let heads = vec![
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 = Read::export(path.as_str(), 2, heads);
println!("{:#}", data);
}More examples
examples/write.rs (line 23)
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
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();
}