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 std::io::Read;
use anyhow::bail;
use quick_xml::events::{BytesStart, Event};

use crate::excel::XmlReader;

/// https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.cellvalue?view=openxml-3.0.1
///
/// This element expresses the value contained in a cell.
/// If the cell contains a string, then this value is an 0 based index into the shared string table, pointing to the actual string value.
/// Otherwise, the value of the cell is expressed directly in this element.
/// Cells containing formulas express the last calculated result of the formula in this element.
///
/// Example
/// ```
/// <c r="C6" s="1" vm="15">
///     <f>CUBEVALUE("xlextdat9 Adventure Works",C$5,$A6)</f>
///     <v>2838512.355</v>
/// </c>
/// // B4 contains the number "360"
/// <c r="B4">
///     <v>360</v>
/// </c>
/// // C4 contains the UTC date 22 November 1976, 08:30
/// <c r="C4" t="d">
///     <v>1976-11-22T08:30Z</v>
/// </c>
/// // A2 contains the shared string at index 1
/// <c r="A2" t="s" s="6">
///     <v>1</v>
/// </c>
/// ```
///
/// v (Cell value)
#[derive(Debug, Clone, PartialEq)]
pub struct XlsxCellValue {
    pub raw_value: String,

    // attributes
    /// Content Contains Significant Whitespace.
    ///
    /// possible values: https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.spaceprocessingmodevalues?view=openxml-3.0.1
    pub space: Option<String>,
}

impl XlsxCellValue {
    pub(crate) fn load(reader: &mut XmlReader<impl Read>, e: &BytesStart) -> anyhow::Result<Self> {
        let mut space: Option<String> = 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"space" => {
                            space = Some(string_value);
                            break;
                        }
                        _ => {}
                    }
                }
                Err(error) => {
                    bail!(error.to_string())
                }
            }
        }

        let mut text = String::new();
        let mut buf: Vec<u8> = Vec::new();
        loop {
            buf.clear();

            match reader.read_event_into(&mut buf) {
                Ok(Event::Text(t)) => text.push_str(&t.unescape()?),
                Ok(Event::End(ref e)) if e.local_name().as_ref() == b"v" => break,
                Ok(Event::Eof) => bail!("unexpected end of file at `v`."),
                Err(e) => bail!(e.to_string()),
                _ => (),
            }
        }

        Ok(Self {
            raw_value: text,
            space,
        })
    }
}