rxls 0.1.2

Native Rust spreadsheet library: reads .xls (BIFF8/5/7), .xlsx, .xlsb, .ods and writes .xlsx. Typed cells, formulas, panic-free, no JVM/POI.
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

//! Print workbook-level and sheet-level metadata without loading caller code
//! with parser internals.
//!
//! ```text
//! cargo run -p rxls --example metadata -- path/to/book.xlsx
//! ```

use std::process::ExitCode;

use rxls::Workbook;

fn print_optional(label: &str, value: Option<&str>) {
    if let Some(value) = value {
        println!("{label}: {value}");
    }
}

fn main() -> ExitCode {
    let Some(path) = std::env::args().nth(1) else {
        eprintln!("usage: metadata <file.xls|.xlsx|.xlsb|.ods>");
        return ExitCode::from(64);
    };
    let bytes = match std::fs::read(&path) {
        Ok(bytes) => bytes,
        Err(e) => {
            eprintln!("read {path}: {e}");
            return ExitCode::from(66);
        }
    };
    let workbook = match Workbook::open(&bytes) {
        Ok(workbook) => workbook,
        Err(e) => {
            eprintln!("parse {path}: {e}");
            return ExitCode::FAILURE;
        }
    };

    let metadata = workbook.metadata();
    println!("file: {path}");
    println!("date1904: {}", metadata.date1904);
    println!("partial: {}", metadata.text_truncated);

    let properties = metadata.properties;
    print_optional("title", properties.title.as_deref());
    print_optional("subject", properties.subject.as_deref());
    print_optional("creator", properties.creator.as_deref());
    print_optional("keywords", properties.keywords.as_deref());
    print_optional("description", properties.description.as_deref());
    print_optional("company", properties.company.as_deref());
    print_optional("created", properties.created.as_deref());

    println!("defined_names: {}", metadata.defined_names.len());
    for (name, refers_to) in metadata.defined_names {
        println!("defined-name\t{name}\t{refers_to}");
    }

    println!("sheets: {}", metadata.sheets.len());
    for (idx, sheet) in metadata.sheets.iter().enumerate() {
        println!(
            "sheet\t{}\t{}\t{:?}\t{:?}",
            idx + 1,
            sheet.name,
            sheet.typ,
            sheet.visible
        );
    }

    ExitCode::SUCCESS
}