crabxl 0.1.0-alpha.11

A Rust spreadsheet library with bounded streaming XLSX reads
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

//! Verify formula cache projections without retaining discarded expressions.
use crabxl::{CellValue, ReadOptions, WorkbookReader};
fn main() -> Result<(), Box<dyn std::error::Error>> {
    let path = std::env::args()
        .nth(1)
        .ok_or("Usage: formula_cache_read <file>")?;
    let mut book = WorkbookReader::open(path)?;
    let options = ReadOptions {
        data_only: true,
        ..ReadOptions::default()
    };
    let rows = book.rows_with_options("Sheet", options)?;
    let mut count = 0u64;
    for row in rows {
        let row = row?;
        if row.cells.len() != 1
            || row.cells[0].value != CellValue::Integer(i64::from(row.index.get()) + 1)
        {
            return Err("Incorrect formula cache projection".into());
        }
        count += 1;
    }
    println!("{count}");
    Ok(())
}