openprxl 0.1.0

A Rust spreadsheet library inspired by Python's openpyxl
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
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161

//! Border styling.

/// A complete cell border.
#[derive(Debug, Clone, Default, PartialEq, Eq, Hash)]
pub struct Border {
    pub left: Option<Side>,
    pub right: Option<Side>,
    pub top: Option<Side>,
    pub bottom: Option<Side>,
    pub diagonal: Option<DiagonalBorder>,
}

impl Border {
    pub fn new() -> Self {
        Self::default()
    }

    pub fn left(mut self, side: Side) -> Self {
        self.left = Some(side);
        self
    }

    pub fn right(mut self, side: Side) -> Self {
        self.right = Some(side);
        self
    }

    pub fn top(mut self, side: Side) -> Self {
        self.top = Some(side);
        self
    }

    pub fn bottom(mut self, side: Side) -> Self {
        self.bottom = Some(side);
        self
    }

    pub fn diagonal(mut self, diagonal: DiagonalBorder) -> Self {
        self.diagonal = Some(diagonal);
        self
    }

    /// Create a thin border on all four sides.
    pub fn thin_all() -> Self {
        let side = Side::thin();
        Self {
            left: Some(side.clone()),
            right: Some(side.clone()),
            top: Some(side.clone()),
            bottom: Some(side.clone()),
            diagonal: None,
        }
    }

    /// Create a medium border on all four sides.
    pub fn medium_all() -> Self {
        let side = Side::medium();
        Self {
            left: Some(side.clone()),
            right: Some(side.clone()),
            top: Some(side.clone()),
            bottom: Some(side.clone()),
            diagonal: None,
        }
    }
}

/// A single border side.
#[derive(Debug, Clone, PartialEq, Eq, Hash)]
pub struct Side {
    pub style: BorderStyle,
    pub color: Option<String>,
}

impl Side {
    pub fn new(style: BorderStyle) -> Self {
        Self {
            style,
            color: None,
        }
    }

    pub fn thin() -> Self {
        Self::new(BorderStyle::Thin)
    }

    pub fn medium() -> Self {
        Self::new(BorderStyle::Medium)
    }

    pub fn thick() -> Self {
        Self::new(BorderStyle::Thick)
    }

    pub fn color<S: Into<String>>(mut self, color: S) -> Self {
        self.color = Some(color.into());
        self
    }
}

/// Border line styles.
#[derive(Debug, Clone, Copy, Default, PartialEq, Eq, Hash)]
pub enum BorderStyle {
    #[default]
    None,
    Thin,
    Medium,
    Thick,
    Dashed,
    Dotted,
    Double,
}

impl std::fmt::Display for BorderStyle {
    fn fmt(&self, f: &mut std::fmt::Formatter<'_>) -> std::fmt::Result {
        match self {
            BorderStyle::None => write!(f, "none"),
            BorderStyle::Thin => write!(f, "thin"),
            BorderStyle::Medium => write!(f, "medium"),
            BorderStyle::Thick => write!(f, "thick"),
            BorderStyle::Dashed => write!(f, "dashed"),
            BorderStyle::Dotted => write!(f, "dotted"),
            BorderStyle::Double => write!(f, "double"),
        }
    }
}

/// Diagonal border settings.
#[derive(Debug, Clone, PartialEq, Eq, Hash)]
pub struct DiagonalBorder {
    pub style: BorderStyle,
    pub color: Option<String>,
    pub up: bool,
    pub down: bool,
}

impl DiagonalBorder {
    pub fn new(style: BorderStyle) -> Self {
        Self {
            style,
            color: None,
            up: false,
            down: false,
        }
    }

    pub fn up(mut self) -> Self {
        self.up = true;
        self
    }

    pub fn down(mut self) -> Self {
        self.down = true;
        self
    }

    pub fn color<S: Into<String>>(mut self, color: S) -> Self {
        self.color = Some(color.into());
        self
    }
}