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

use anyhow::bail;
use gradient_fill::XlsxGradientFill;
use pattern_fill::XlsxPatternFill;
use quick_xml::events::Event;
use std::io::Read;

use crate::excel::XmlReader;

pub mod gradient_fill;
pub mod pattern_fill;

/// Example
/// ```
/// <fills count="3">
///     <fill>
///         <patternFill patternType="none" />
///     </fill>
///     <fill>
///         <patternFill patternType="gray125" />
///     </fill>
///      </fill>
/// </fills>
/// ```
pub type XlsxFills = Vec<XlsxFill>;

pub(crate) fn load_fills(reader: &mut XmlReader<impl Read>) -> anyhow::Result<XlsxFills> {
    let mut buf = Vec::new();
    let mut fills: Vec<XlsxFill> = vec![];

    loop {
        buf.clear();

        match reader.read_event_into(&mut buf) {
            Ok(Event::Start(ref e)) if e.local_name().as_ref() == b"fill" => {
                let Some(fill) = XlsxFill::load(reader)? else {
                    continue;
                };
                fills.push(fill);
            }
            Ok(Event::End(ref e)) if e.local_name().as_ref() == b"fills" => break,
            Ok(Event::Eof) => bail!("unexpected end of file."),
            Err(e) => bail!(e.to_string()),
            _ => (),
        }
    }

    Ok(fills)
}

/// fill (Fill)
///
/// https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.fill?view=openxml-3.0.1
#[derive(Debug, Clone, PartialEq)]
pub enum XlsxFill {
    // children
    // xml tag name: patternFill
    PatternFill(XlsxPatternFill),
    // xml tag name: gradientFill
    GradientFill(XlsxGradientFill),
}

impl XlsxFill {
    pub(crate) fn load(reader: &mut XmlReader<impl Read>) -> anyhow::Result<Option<Self>> {
        let mut buf = Vec::new();

        loop {
            buf.clear();

            match reader.read_event_into(&mut buf) {
                Ok(Event::Start(ref e)) if e.local_name().as_ref() == b"patternFill" => {
                    let pattern_fill = XlsxPatternFill::load(reader, e)?;
                    return Ok(Some(XlsxFill::PatternFill(pattern_fill)));
                }

                Ok(Event::Start(ref e)) if e.local_name().as_ref() == b"gradientFill" => {
                    let gradient_fill = XlsxGradientFill::load(reader, e)?;
                    return Ok(Some(XlsxFill::GradientFill(gradient_fill)));
                }

                Ok(Event::End(ref e)) if e.local_name().as_ref() == b"fill" => break,
                Ok(Event::Eof) => bail!("unexpected end of file."),
                Err(e) => bail!(e.to_string()),
                _ => (),
            }
        }

        Ok(None)
    }
}