excelstream 0.6.3-alpha

High-performance streaming Excel library - Read/write large XLSX files with memory-efficient streaming
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

//! Streaming read example - Process large Excel files with minimal memory usage

use excelstream::ExcelReader;

fn main() -> Result<(), Box<dyn std::error::Error>> {
    println!("Streaming read example - Processing large Excel file");
    println!("This example demonstrates memory-efficient reading\n");

    // Open Excel file
    let mut reader = ExcelReader::open("examples/large_output.xlsx")?;

    // Get dimensions
    let (rows, cols) = reader.dimensions("Sheet1")?;
    println!("File dimensions: {} rows x {} columns\n", rows, cols);

    // Stream through rows one at a time
    let mut row_count = 0;
    let mut total_sum = 0.0;

    println!("Processing rows...");
    for row_result in reader.rows("Sheet1")? {
        let row = row_result?;
        row_count += 1;

        // Process each row (e.g., sum numeric values)
        for cell in &row.cells {
            if let Some(value) = cell.as_f64() {
                total_sum += value;
            }
        }

        // Print progress every 1000 rows
        if row_count % 1000 == 0 {
            println!("  Processed {} rows...", row_count);
        }
    }

    println!("\nProcessing complete:");
    println!("  Total rows processed: {}", row_count);
    println!("  Sum of all numeric values: {}", total_sum);

    Ok(())
}