Formula

A parser and evaluator of spreadsheet-like formulas

Formula is in its early stages and is not ready for production use.

So far we have the following features:

• 18 date time functions
• 26 text functions
• 26 math functions
• 7 logical functions
• 2 web functions
• plus all arithmetic and comparison operators

Installation and usage

Rust

Add this library to your project with cargo add formula or add formula = "*" to your Cargo.toml file.

Use it similar to the following code:

use formula::{Formula, Expr, Result};

fn main() -> Result<()> {
    let formula = Formula::new("=UPPER(TRIM('   Hello '))")?;
    let value = formula.parse()?;
    assert_eq!(value, Expr::String("HELLO".to_string()));
    Ok(())
}

JavaScript

Add this library to your project with npm install formula-wasm or add formula-wasm to your package.json file.

Use it similar to the following code:

import { parse } from 'formula-wasm';

const value = parse('=UPPER(TRIM("   Hello "))');
console.assert(value, "HELLO");

What we do not support, yet:

• We don't support all existing functions in the world, but we would like to add more of them, like Excel functions, Google Sheets functions, and so on
• At the moment, we don't support table data. It means you need to extract table data and pass theirs values to this library
• We do not support simple formulas like 1+1 or as argument like AND(1>3, 1<3) or SUM(2-1, 2). Instead, you can use our F. functions like AND(F.GT(1, 3), F.LT(1, 3)) or SUM(F.SUB(2, 1), 2)
• We still do not support parentheses to change the order of operations, but you can use our F. functions. So for example instead of 2*(1+1), you should use F.MUL(2, F.ADD(1, 1))

Contributing

We would love to have your contribution! Please read our contributing guidelines to get started.

Inspired by

• formulajs
• hyperformula

License

This project is licensed under the MIT license. See the LICENSE file for more info.