ironcalc 0.7.1

The democratization of spreadsheets
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

#![allow(clippy::unwrap_used)]
#![allow(clippy::panic)]

//! Tests an Excel xlsx file.
//! Returns a list of differences in json format.
//! Saves an IronCalc version
//! This is primary for QA internal testing and will be superseded by an official
//! IronCalc CLI.
//!
//! Usage: test file.xlsx

use std::path;

use ironcalc::{compare::test_file, export::save_to_xlsx, import::load_from_xlsx};

fn main() {
    let args: Vec<_> = std::env::args().collect();
    if args.len() != 2 {
        panic!("Usage: {} <file.xlsx>", args[0]);
    }
    // first test the file
    let file_name = &args[1];
    println!("Testing file: {file_name}");
    if let Err(message) = test_file(file_name) {
        println!("{message}");
        panic!("Model was evaluated inconsistently with XLSX data.")
    }

    // save a copy my_xlsx_file.xlsx => my_xlsx_file.output.xlsx
    let file_path = path::Path::new(file_name);
    let base_name = file_path.file_stem().unwrap().to_str().unwrap();
    let output_file_name = &format!("{base_name}.output.xlsx");
    let mut model = load_from_xlsx(file_name, "en-GB", "UTC", "en").unwrap();
    model.evaluate();
    println!("Saving result as: {output_file_name}. Please open with Excel and test.");
    save_to_xlsx(&model, output_file_name).unwrap();
}