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

use std::io::Read;
use anyhow::bail;
use quick_xml::events::{BytesStart, Event};

use crate::excel::XmlReader;

use crate::raw::drawing::{
    effect::effect_style_list::{load_effect_style_list, XlsxEffectStyleList},
    fill::{
        load_bg_fill_style_lst, load_fill_style_lst, XlsxBackgroundFillStyleList, XlsxFillStyleList,
    },
    line::{load_line_style_list, XlsxLineStyleList},
};

/// https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.drawing.formatscheme?view=openxml-3.0.1
///
/// Example:
/// ```
/// <a:fmtScheme name="Office">
///     <a:fillStyleLst>
///         <a:solidFill>
///             <a:schemeClr val="phClr" />
///         </a:solidFill>
///         <a:gradFill rotWithShape="1">
///             <a:gsLst>
///                 <a:gs pos="0">
///                     <a:schemeClr val="phClr">
///                         <a:satMod val="103000" />
///                         <a:lumMod val="102000" />
///                         <a:tint val="94000" />
///                     </a:schemeClr>
///                 </a:gs>
///                 <a:gs pos="50000">
///                     <a:schemeClr val="phClr">
///                         <a:satMod val="110000" />
///                         <a:lumMod val="100000" />
///                         <a:shade val="100000" />
///                     </a:schemeClr>
///                 /a:gs>
///             </a:gsLst>
///             <a:lin ang="5400000" scaled="0" />
///         </a:gradFill>
///     </a:fillStyleLst>
///     <a:lnStyleLst>
///         <a:ln w="6350" cap="flat" cmpd="sng" algn="ctr">
///             <a:solidFill>
///                 <a:schemeClr val="phClr" />
///             </a:solidFill>
///             <a:prstDash val="solid" />
///             <a:miter lim="800000" />
///         </a:ln>
///     </a:lnStyleLst>
///     <a:effectStyleLst>
///         <a:effectStyle>
///             <a:effectLst>
///                 <a:outerShdw blurRad="57150" dist="19050" dir="5400000" algn="ctr" rotWithShape="0">
///                     <a:srgbClr val="000000">
///                         <a:alpha val="63000" />
///                     </a:srgbClr>
///                 </a:outerShdw>
///             </a:effectLst>
///         </a:effectStyle>
///     </a:effectStyleLst>
///     <a:bgFillStyleLst>
///         <a:solidFill>
///             <a:schemeClr val="phClr" />
///         </a:solidFill>
///     </a:bgFillStyleLst>
/// </a:fmtScheme>
/// ```
// tag: fmtScheme
#[derive(Debug, Clone, PartialEq)]
pub struct XlsxFormatScheme {
    // attribute
    pub name: Option<String>,

    // children
    /// FillStyleList: https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.drawing.fillstylelist?view=openxml-3.0.1
    /// This element defines a set of three fill styles that are used within a theme.
    /// The three fill styles are arranged in order from subtle to moderate to intense.
    // tag: fillStyleLst
    pub fill_style_lst: Option<XlsxFillStyleList>,

    /// BackgroundFillStyleList: https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.drawing.backgroundfillstylelist?view=openxml-3.0.1
    /// This element defines a set of three background fills that are used within a theme.
    /// The three fill styles are arranged in order from subtle to moderate to intense.
    // tag: bgFillStyleLst
    pub bg_fill_style_lst: Option<XlsxBackgroundFillStyleList>,

    /// EffectStyleList: https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.drawing.effectstylelist?view=openxml-3.0.1
    /// This element defines a set of three effect styles that create the effect style list for a theme.
    /// The effect styles are arranged in order of subtle to moderate to intense.
    // tag: effectStyleLst
    pub effect_style_lst: Option<XlsxEffectStyleList>,

    /// LineStyleList: https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.drawing.linestylelist?view=openxml-3.0.1
    /// defines a list of three line styles for use within a theme.
    /// The three line styles are arranged in order from subtle to moderate to intense versions of lines.
    // tag: lnStyleLst
    pub line_style_lst: Option<XlsxLineStyleList>,
}

impl XlsxFormatScheme {
    pub(crate) fn load(reader: &mut XmlReader<impl Read>, e: &BytesStart) -> anyhow::Result<Self> {
        let mut buf = Vec::new();
        let mut scheme = Self {
            name: None,
            fill_style_lst: None,
            bg_fill_style_lst: None,
            effect_style_lst: None,
            line_style_lst: None,
        };
        let attributes = e.attributes();
        for a in attributes {
            match a {
                Ok(a) => {
                    let string_value = String::from_utf8(a.value.to_vec())?;
                    match a.key.local_name().as_ref() {
                        b"name" => {
                            scheme.name = Some(string_value);
                            break;
                        }
                        _ => {}
                    }
                }
                Err(error) => {
                    bail!(error.to_string())
                }
            }
        }

        loop {
            buf.clear();

            match reader.read_event_into(&mut buf) {
                Ok(Event::Start(ref e)) if e.local_name().as_ref() == b"fillStyleLst" => {
                    scheme.fill_style_lst = Some(load_fill_style_lst(reader)?);
                }
                Ok(Event::Start(ref e)) if e.local_name().as_ref() == b"bgFillStyleLst" => {
                    scheme.bg_fill_style_lst = Some(load_bg_fill_style_lst(reader)?);
                }
                Ok(Event::Start(ref e)) if e.local_name().as_ref() == b"effectStyleLst" => {
                    let style_list = load_effect_style_list(reader)?;
                    scheme.effect_style_lst = Some(style_list);
                }
                Ok(Event::Start(ref e)) if e.local_name().as_ref() == b"lnStyleLst" => {
                    let style_list = load_line_style_list(reader)?;
                    scheme.line_style_lst = Some(style_list);
                }
                Ok(Event::End(ref e)) if e.local_name().as_ref() == b"fmtScheme" => break,
                Ok(Event::Eof) => bail!("unexpected end of file."),
                Err(e) => bail!(e.to_string()),
                _ => (),
            }
        }

        Ok(scheme)
    }
}