miniexcel 0.1.0

Experimental Rust XLSX reader and writer for MiniExcel
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

use miniexcel::{
    AggregateOp, AggregateSpec, ComparisonOp, FilterExpr, HeaderMode, MiniExcel, QueryLiteral,
    QueryPlan, ReadOptions,
};

fn main() -> miniexcel::Result<()> {
    let path = std::env::args().nth(1).unwrap_or_else(|| "book.xlsx".to_owned());
    let options = ReadOptions::new().with_header_mode(HeaderMode::FirstRow);
    let plan = QueryPlan::new([
        AggregateSpec::count_all("rows"),
        AggregateSpec::column(AggregateOp::Sum, "Amount", "totalAmount"),
        AggregateSpec::column(AggregateOp::Average, "Amount", "averageAmount"),
    ])
    .with_filter(FilterExpr::compare(
        "Status",
        ComparisonOp::Eq,
        QueryLiteral::String("Ready".to_owned()),
    ))
    .with_group_by(["Category", "Region"])
    .with_max_groups(10_000)
    .with_limit(200);

    let result = MiniExcel::analyze_with_options(path, &options, &plan)?;
    println!("{}", serde_json::to_string_pretty(&result).expect("serialize analysis"));
    Ok(())
}