1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
// SPDX-License-Identifier: MIT OR Apache-2.0
//
// Copyright 2022-2025, John McNamara, jmcnamara@cpan.org
//! An example of writing a Polar Rust dataframe to an Excel file. This example
//! demonstrates converting strings to formulas. This example uses structured
//! table formulas.
use polars::prelude::*;
use polars_excel_writer::PolarsExcelWriter;
fn main() -> PolarsResult<()> {
// Create a sample dataframe for the example.
let df: DataFrame = df!(
"Region" => &["North", "South", "East", "West"],
"Q1" => &[80, 20, 75, 85],
"Q2" => &[80, 50, 65, 80],
"Q3" => &[75, 60, 75, 80],
"Q4" => &[70, 70, 65, 85],
"Total" => &["=SUM(Table1[@[Q1]:[Q4]])",
"=SUM(Table1[@[Q1]:[Q4]])",
"=SUM(Table1[@[Q1]:[Q4]])",
"=SUM(Table1[@[Q1]:[Q4]])"],
)?;
// Create a new Excel writer.
let mut excel_writer = PolarsExcelWriter::new();
// Treat the Total column as a list of formulas.
excel_writer.enable_column_formulas("Total");
// Write the dataframe to Excel.
excel_writer.write_dataframe(&df)?;
// Save the file to disk.
excel_writer.save("dataframe.xlsx")?;
Ok(())
}