XLFormula Engine

XLFormula Engine is a Rust crate for parsing and evaluating Excel formulas. It currently works with f32 types.

Features

It supports:

Any numbers, negative and positive, as float or integer;
Arithmetic operations +, -, /, *, ^;
Logical operations AND(), OR(), NOT(), XOR();
Comparison operations =, >, >=, <, <=, <>;
String operation & (concatenation);
Build-in variables TRUE, FALSE;
Excel functions ABS(), SUM(), PRODUCT().

Installation

Add the corresponding entry to your Cargo.toml dependency list:

[dependencies]
xlformula_engine = "0.1.0"

and add this to your crate root:

extern crate xlformula_engine;

Examples

Here is a simple example of parsing an Excel formula string and evaluating to a result:

extern crate xlformula_engine;
use xlformula_engine::calculate;
use xlformula_engine::parse_formula;

fn main() {
    let formula = parse_formula::parse_string_to_formula(&"=1+2");
    let result = calculate::calculate_formula(formula, None);
    println!("Result is {}", calculate::result_to_string(result));
}

Another example with a formula with references:

extern crate xlformula_engine;
use xlformula_engine::calculate;
use xlformula_engine::parse_formula;
use xlformula_engine::types;

fn main() {
    let data_function = |s: String| match s.as_str() {
        "A" => types::Value::Text("=1+B".to_string()),
        "B" => types::Value::Number(3.0),
        _ => types::Value::Error(types::Error::Value),
    };
    let formula = parse_formula::parse_string_to_formula(&"=A+B");
    let result = calculate::calculate_formula(formula, Some(data_function));
    println!("Result is {}", calculate::result_to_string(result));
}

License

Licensed under MIT License (see the LICENSE file for the full text).

Contact