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
27
28
29
30

use std::path::PathBuf;

use chrono::NaiveDate;
use miniexcel::{CellValue, DynamicRow, MiniExcel, WriteOptions};

fn main() -> miniexcel::Result<()> {
    let output = std::env::args()
        .nth(1)
        .map_or_else(|| std::env::temp_dir().join("miniexcel-rust-example.xlsx"), PathBuf::from);

    let mut first = DynamicRow::new();
    first.insert("Name".to_owned(), CellValue::String("MiniExcel".to_owned()));
    first.insert("Version".to_owned(), CellValue::Int(2));
    first.insert(
        "ReleasedOn".to_owned(),
        CellValue::Date(NaiveDate::from_ymd_opt(2025, 1, 2).expect("valid example date")),
    );

    let mut second = DynamicRow::new();
    second.insert("Name".to_owned(), CellValue::String("MiniExcel Rust".to_owned()));
    second.insert("Version".to_owned(), CellValue::Int(1));

    let rows = [first, second];
    let sheet_name = "Releases";
    let options = WriteOptions::new().with_sheet_name(sheet_name);
    MiniExcel::save_as_with_options(&output, &rows, &options)?;

    println!("Wrote {} rows to '{sheet_name}' in {}", rows.len(), output.display());
    Ok(())
}