csvpp 0.8.0

Compile csv++ source code to a target spreadsheet format
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
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122

mod common;
use common::assert_fixture_compiles_ok;

#[test]
fn all_features_csv() {
    assert_fixture_compiles_ok("all_features", "csv");
}

#[test]
fn all_features_shorthand_csv_no_code_section() {
    assert_fixture_compiles_ok("all_features_shorthand", "csv");
}

fn get_cell<'a>(
    spreadsheet: &'a umya_spreadsheet::Spreadsheet,
    cell: &str,
) -> &'a umya_spreadsheet::Cell {
    spreadsheet
        .get_sheet_by_name("all_features")
        .unwrap()
        .get_cell(cell)
        .unwrap()
}

#[test]
fn all_features_excel() {
    let setup = assert_fixture_compiles_ok("all_features", "xlsx");

    let s = umya_spreadsheet::reader::xlsx::read(&setup.output_path).unwrap();
    // borders
    dbg!(get_cell(&s, "B2").get_style());
    assert_eq!(
        get_cell(&s, "B2")
            .get_style()
            .get_borders()
            .unwrap()
            .get_top()
            .get_border_style(),
        umya_spreadsheet::structs::Border::BORDER_THIN
    );

    // color
    assert_eq!(
        get_cell(&s, "B13")
            .get_style()
            .get_fill()
            .unwrap()
            .get_pattern_fill()
            .unwrap()
            .get_foreground_color()
            .unwrap()
            .get_argb(),
        "FF0000FF"
    );
    assert_eq!(
        get_cell(&s, "B22")
            .get_style()
            .get_font()
            .unwrap()
            .get_color()
            .get_argb(),
        "FF0000FF"
    );

    // text formats
    assert!(get_cell(&s, "B52")
        .get_style()
        .get_font()
        .unwrap()
        .get_bold());
    assert!(get_cell(&s, "B53")
        .get_style()
        .get_font()
        .unwrap()
        .get_italic());
    assert_eq!(
        get_cell(&s, "B54")
            .get_style()
            .get_font()
            .unwrap()
            .get_underline(),
        "single"
    );
    assert!(get_cell(&s, "B55")
        .get_style()
        .get_font()
        .unwrap()
        .get_strikethrough());

    // fonts
    assert_eq!(
        get_cell(&s, "B30")
            .get_style()
            .get_font()
            .unwrap()
            .get_size(),
        &20.0
    );

    // alignments
    assert_eq!(
        get_cell(&s, "B34")
            .get_style()
            .get_alignment()
            .unwrap()
            .get_horizontal(),
        &umya_spreadsheet::HorizontalAlignmentValues::Left
    );
    assert_eq!(
        get_cell(&s, "B84")
            .get_style()
            .get_alignment()
            .unwrap()
            .get_vertical(),
        &umya_spreadsheet::VerticalAlignmentValues::Top
    );
}

// TODO:
// #[test]
// fn all_features_google_sheets() {
// }