excelstream 0.20.2

High-performance streaming Excel & CSV library with S3/GCS cloud support and Parquet conversion - Ultra-low memory usage
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

use excelstream::ExcelWriter;
use std::fs;
use std::hint::black_box;

#[global_allocator]
static ALLOC: dhat::Alloc = dhat::Alloc;

fn main() -> Result<(), Box<dyn std::error::Error>> {
    let _profiler = dhat::Profiler::new_heap();

    let path = "memory_bench_test.xlsx";
    // Ensure cleanup from previous runs
    if std::path::Path::new(path).exists() {
        fs::remove_file(path)?;
    }

    let mut writer = ExcelWriter::new(path)?;

    // Simulate writing 100,000 rows
    for _ in 0..100_000 {
        writer.write_row(black_box([
            "Column 1 Data",
            "Column 2 Data",
            "12345",
            "2023-01-01",
            "Some longer text content to simulate real world data usage",
        ]))?;
    }

    writer.save()?;

    // Cleanup
    if std::path::Path::new(path).exists() {
        fs::remove_file(path)?;
    }

    println!("Benchmark complete");
    Ok(())
}