Quickstarts
Rust Quickstart
Create a workbook, set cells, evaluate a formula, and read the result in Rust.
1) Add dependencies
[dependencies]
formualizer-workbook = "0.3"
formualizer-common = "0.3"2) Evaluate a simple formula
use formualizer_common::LiteralValue;
use formualizer_workbook::Workbook;
fn main() -> Result<(), Box<dyn std::error::Error>> {
let mut wb = Workbook::new();
wb.add_sheet("Sheet1")?;
wb.set_value("Sheet1", 1, 1, LiteralValue::Number(100.0))?; // A1
wb.set_value("Sheet1", 2, 1, LiteralValue::Number(20.0))?; // A2
wb.set_formula("Sheet1", 1, 2, "=A1-A2")?; // B1
let result = wb.evaluate_cell("Sheet1", 1, 2)?;
assert_eq!(result, LiteralValue::Number(80.0));
Ok(())
}3) Run
cargo run