array_formula/
array_formula.rs

1use edit_xlsx::{Workbook, WorkbookResult, Write};
2
3fn main() -> WorkbookResult<()> {
4    // Create a new workbook
5    let mut workbook = Workbook::new();
6    // Use the default worksheet
7    let worksheet = workbook.get_worksheet_mut(1)?;
8    // Write some test data.
9    worksheet.write("B1", 500)?;
10    worksheet.write("B2", 10)?;
11    worksheet.write("B5", 1)?;
12    worksheet.write("B6", 2)?;
13    worksheet.write("B7", 3)?;
14    worksheet.write("C1", 300)?;
15    worksheet.write("C2", 15)?;
16    worksheet.write("C5", 20234)?;
17    worksheet.write("C6", 21003)?;
18    worksheet.write("C7", 10000)?;
19    // Write an array formula that returns a single value
20    worksheet.write_formula("A1", "_xlfn.SUM(B1:C1*B2:C2)")?;
21    // Same as above but more verbose.
22    worksheet.write_array_formula("A2", "_xlfn.SUM(B1:C1*B2:C2)")?;
23    // Write an array formula that returns a range of values
24    worksheet.write_array_formula("A5", "_xlfn.TREND(C5:C7,B5:B7)")?;
25
26    workbook.save_as("examples/array_formula.xlsx")?;
27    Ok(())
28}
array_formula/array_formula.rs

array_formula/
array_formula.rs
