excel_reader 2.0.2 

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
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181

#[cfg(feature = "serde")]
use serde::Serialize;

/// https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.drawing.presetpatternvalues?view=openxml-3.0.1
///
/// * Cross
/// * DarkDownwardDiagonal
/// * DarkHorizontal
/// * DarkUpwardDiagonal
/// * DarkVertical
/// * DashedDownwardDiagonal
/// * DashedHorizontal
/// * DashedUpwardDiagonal
/// * DashedVertical
/// * DiagonalBrick
/// * DiagonalCross
/// * Divot
/// * DotGrid
/// * DottedDiamond
/// * DownwardDiagonal
/// * Horizontal
/// * HorizontalBrick
/// * LargeCheck
/// * LargeConfetti
/// * LargeGrid
/// * LightDownwardDiagonal
/// * LightHorizontal
/// * LightUpwardDiagonal
/// * LightVertical
/// * NarrowHorizontal
/// * NarrowVertical
/// * OpenDiamond
/// * Percent10
/// * Percent20
/// * Percent25
/// * Percent30
/// * Percent40
/// * Percent5
/// * Percent50
/// * Percent60
/// * Percent70
/// * Percent75
/// * Percent80
/// * Percent90
/// * Plaid
/// * Shingle
/// * SmallCheck
/// * SmallConfetti
/// * SmallGrid
/// * SolidDiamond
/// * Sphere
/// * Trellis
/// * UpwardDiagonal
/// * Vertical
/// * Wave
/// * Weave
/// * WideDownwardDiagonal
/// * WideUpwardDiagonal
/// * ZigZag
#[derive(Debug, Clone, PartialEq)]
#[cfg_attr(feature = "serde", derive(Serialize))]
#[cfg_attr(feature = "serde", serde(rename_all = "snake_case"))]
pub enum PresetPatternValues {
    Cross,
    DarkDownwardDiagonal,
    DarkHorizontal,
    DarkUpwardDiagonal,
    DarkVertical,
    DashedDownwardDiagonal,
    DashedHorizontal,
    DashedUpwardDiagonal,
    DashedVertical,
    DiagonalBrick,
    DiagonalCross,
    Divot,
    DotGrid,
    DottedDiamond,
    DownwardDiagonal,
    Horizontal,
    HorizontalBrick,
    LargeCheck,
    LargeConfetti,
    LargeGrid,
    LightDownwardDiagonal,
    LightHorizontal,
    LightUpwardDiagonal,
    LightVertical,
    NarrowHorizontal,
    NarrowVertical,
    OpenDiamond,
    Percent10,
    Percent20,
    Percent25,
    Percent30,
    Percent40,
    Percent5,
    Percent50,
    Percent60,
    Percent70,
    Percent75,
    Percent80,
    Percent90,
    Plaid,
    Shingle,
    SmallCheck,
    SmallConfetti,
    SmallGrid,
    SolidDiamond,
    Sphere,
    Trellis,
    UpwardDiagonal,
    Vertical,
    Wave,
    Weave,
    WideDownwardDiagonal,
    WideUpwardDiagonal,
    ZigZag,
}

impl PresetPatternValues {
    pub(crate) fn from_string(s: Option<String>) -> Option<Self> {
        let Some(s) = s else { return None };
        return Some(match s.as_ref() {
            "cross" => Self::Cross,
            "dkDnDiag" => Self::DarkDownwardDiagonal,
            "dkHorz" => Self::DarkHorizontal,
            "dkUpDiag" => Self::DarkUpwardDiagonal,
            "dkVert" => Self::DarkVertical,
            "dashDnDiag" => Self::DashedDownwardDiagonal,
            "dashHorz" => Self::DashedHorizontal,
            "dashUpDiag" => Self::DashedUpwardDiagonal,
            "dashVert" => Self::DashedVertical,
            "diagBrick" => Self::DiagonalBrick,
            "diagCross" => Self::DiagonalCross,
            "divot" => Self::Divot,
            "dotGrid" => Self::DotGrid,
            "dotDmnd" => Self::DottedDiamond,
            "dnDiag" => Self::DownwardDiagonal,
            "horz" => Self::Horizontal,
            "horzBrick" => Self::HorizontalBrick,
            "lgCheck" => Self::LargeCheck,
            "lgConfetti" => Self::LargeConfetti,
            "lgGrid" => Self::LargeGrid,
            "ltDnDiag" => Self::LightDownwardDiagonal,
            "ltHorz" => Self::LightHorizontal,
            "ltUpDiag" => Self::LightUpwardDiagonal,
            "ltVert" => Self::LightVertical,
            "narHorz" => Self::NarrowHorizontal,
            "narVert" => Self::NarrowVertical,
            "openDmnd" => Self::OpenDiamond,
            "pct10" => Self::Percent10,
            "pct20" => Self::Percent20,
            "pct25" => Self::Percent25,
            "pct30" => Self::Percent30,
            "pct40" => Self::Percent40,
            "pct5" => Self::Percent5,
            "pct50" => Self::Percent50,
            "pct60" => Self::Percent60,
            "pct70" => Self::Percent70,
            "pct75" => Self::Percent75,
            "pct80" => Self::Percent80,
            "pct90" => Self::Percent90,
            "plaid" => Self::Plaid,
            "shingle" => Self::Shingle,
            "smCheck" => Self::SmallCheck,
            "smConfetti" => Self::SmallConfetti,
            "smGrid" => Self::SmallGrid,
            "solidDmnd" => Self::SolidDiamond,
            "sphere" => Self::Sphere,
            "trellis" => Self::Trellis,
            "upDiag" => Self::UpwardDiagonal,
            "vert" => Self::Vertical,
            "wave" => Self::Wave,
            "weave" => Self::Weave,
            "wdDnDiag" => Self::WideDownwardDiagonal,
            "wdUpDiag" => Self::WideUpwardDiagonal,
            "zigZag" => Self::ZigZag,
            _ => return None,
        });
    }
}