Quickstarts
First Workbook in 5 Minutes
End-to-end mini-flow: write inputs, set formula, evaluate output.
This walkthrough gives one tiny but realistic workbook flow:
- Inputs in
A1andA2 - Formula in
B1 - Evaluate and assert result
Complete example
Pricing discount: A1 base price, A2 discount → B1 result
use formualizer_common::LiteralValue;use formualizer_workbook::Workbook;fn main() -> Result<(), Box<dyn std::error::Error>> { let mut wb = Workbook::new(); wb.add_sheet("Pricing")?; // Inputs wb.set_value("Pricing", 1, 1, LiteralValue::Number(100.0))?; // A1 base price wb.set_value("Pricing", 2, 1, LiteralValue::Number(0.15))?; // A2 discount // Formula wb.set_formula("Pricing", 1, 2, "=A1*(1-A2)")?; // B1 // Evaluate let result = wb.evaluate_cell("Pricing", 1, 2)?; assert_eq!(result, LiteralValue::Number(85.0)); Ok(())}For runtime-specific setup details, see: