karo 0.1.2

Spreadsheet export
Documentation 
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88

//! A simple program to write some data to an Excel file.

use chrono::{DateTime, TimeZone, Utc};
use karo::{index, Format, NumFormat, Workbook};

struct Expense {
    item: &'static str,
    cost: f64,
    datetime: DateTime<Utc>,
}

fn main() -> karo::Result<()> {
    let expenses = [
        Expense {
            item: "Rent",
            cost: 1000f64,
            datetime: Utc.ymd(2013, 1, 13).and_hms(0, 0, 0),
        },
        Expense {
            item: "Gas",
            cost: 100f64,
            datetime: Utc.ymd(2013, 1, 14).and_hms(0, 0, 0),
        },
        Expense {
            item: "Food",
            cost: 300f64,
            datetime: Utc.ymd(2013, 1, 16).and_hms(0, 0, 0),
        },
        Expense {
            item: "Gym",
            cost: 50f64,
            datetime: Utc.ymd(2013, 1, 20).and_hms(0, 0, 0),
        },
    ];

    // Create a new workbook.
    let mut workbook = Workbook::new();

    {
        // Add a worksheet with a user defined name.
        let worksheet = workbook.add_worksheet(None)?;

        // Add a bold format to use to highlight cells.
        let mut bold = Format::default();
        bold.font.bold = true;

        // Add a number format for cells with money.
        let mut money = Format::default();
        money.num_format = NumFormat::from_format_string("$#,##0");

        // Add a number format for cells with money.
        let mut date = Format::default();
        date.num_format = NumFormat::from_format_string("mmmm d yyyy");

        let mut row = 0u32;

        worksheet.write_string(index(row, 0)?, "Item", Some(&bold))?;
        worksheet.write_string(index(row, 1)?, "Cost", Some(&bold))?;
        row += 1;

        for Expense {
            item,
            cost,
            datetime,
        } in expenses.iter()
        {
            worksheet.write_string(index(row, 0)?, item, None)?;
            worksheet.write_datetime(
                index(row, 1)?,
                *datetime,
                Some(&date),
            )?;
            worksheet.write_number(index(row, 2)?, *cost, Some(&money))?;
            row += 1;
        }

        worksheet.write_string(index(row, 0)?, "Total", Some(&bold))?;
        worksheet.write_formula(
            index(row, 2)?,
            "=SUM(C2:C5)",
            Some(&money),
        )?;
    }

    workbook.write_file("tutorial03.xlsx")?;

    Ok(())
}