edit-xlsx 0.4.4

A quick and easy-to-use Rust library for Excel file editing.
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

use serde::{Deserialize, Serialize};
use crate::FormatColor;
use crate::xml::common::FromFormat;
use crate::xml::style::color::Color;

#[derive(Debug, Clone, Deserialize, Serialize, Default)]
pub(crate) struct SheetPr {
    #[serde(rename = "@codeName", default, skip_serializing_if = "Option::is_none")]
    code_name: Option<String>,
    #[serde(rename = "pageSetUpPr", default, skip_serializing_if = "Option::is_none")]
    page_set_up_pr: Option<PageSetUpPr>,
    #[serde(rename = "tabColor", default, skip_serializing_if = "Option::is_none")]
    tab_color: Option<Color>,
    #[serde(rename = "outlinePr", default, skip_serializing_if = "Option::is_none")]
    outline_pr: Option<OutlinePr>,
}

#[derive(Debug, Clone, Deserialize, Serialize)]
struct PageSetUpPr {
    #[serde(rename = "@fitToPage", default, skip_serializing_if = "Option::is_none")]
    fit_to_page: Option<u8>,
}

#[derive(Debug, Clone, Deserialize, Serialize)]
struct OutlinePr {
    #[serde(rename = "@applyStyles")]
    apply_styles: u8,
    #[serde(rename = "@summaryBelow")]
    summary_below: u8,
    #[serde(rename = "@summaryRight")]
    summary_right: u8,
    #[serde(rename = "@showOutlineSymbols")]
    show_outline_symbols: u8,
}

impl Default for OutlinePr {
    fn default() -> Self {
        Self {
            apply_styles: 0,
            summary_below: 1,
            summary_right: 1,
            show_outline_symbols: 1,
        }
    }
}

impl SheetPr {
    fn new(color: &FormatColor) -> SheetPr {
        SheetPr {
            code_name: None,
            page_set_up_pr: None,
            tab_color: Default::default(), //Color::from_format(color),
            outline_pr: None,
        }
    }

    pub(crate) fn set_tab_color(&mut self, color: &FormatColor) {
        let tab_color = Color::from_format(color);
        self.tab_color = Some(tab_color);
    }

    pub(crate) fn set_outline_pr(&mut self, visible: bool, symbols_below: bool, symbols_right: bool, auto_style: bool) {
        let mut outline_pr = self.outline_pr.take().unwrap_or_default();
        outline_pr.apply_styles = auto_style as u8;
        outline_pr.show_outline_symbols = visible as u8;
        outline_pr.summary_below = symbols_below as u8;
        outline_pr.summary_right = symbols_right as u8;
        self.outline_pr = Some(outline_pr);
    }
}