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

//! Release-mode package-preserving edit/save performance consumer.
//!
//! ```text
//! cargo run --release --example edit_save_benchmark -- input.xlsx output.xlsx
//! ```

use std::io::{Error as IoError, ErrorKind};

use rxls::{Cell, Spreadsheet};

fn main() -> Result<(), Box<dyn std::error::Error>> {
    let mut args = std::env::args_os().skip(1);
    let input = args.next().ok_or_else(|| {
        IoError::new(
            ErrorKind::InvalidInput,
            "usage: edit_save_benchmark INPUT.xlsx OUTPUT.xlsx",
        )
    })?;
    let output = args.next().ok_or_else(|| {
        IoError::new(
            ErrorKind::InvalidInput,
            "usage: edit_save_benchmark INPUT.xlsx OUTPUT.xlsx",
        )
    })?;
    if args.next().is_some() {
        return Err(IoError::new(
            ErrorKind::InvalidInput,
            "usage: edit_save_benchmark INPUT.xlsx OUTPUT.xlsx",
        )
        .into());
    }

    let bytes = std::fs::read(input)?;
    let mut spreadsheet = Spreadsheet::open(&bytes)?;
    let sheet_name = spreadsheet
        .workbook()
        .sheet_names()
        .first()
        .ok_or_else(|| IoError::new(ErrorKind::InvalidData, "workbook has no worksheets"))?
        .to_string();
    spreadsheet.set_cell_value(
        &sheet_name,
        0,
        0,
        Cell::Text("rxls package-preserving edit benchmark".to_string()),
    )?;
    std::fs::write(output, spreadsheet.save()?)?;
    Ok(())
}