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

pub mod phonetic_properties;
pub mod phonetic_run;
pub mod rich_text_run;
pub mod run_properties;

use anyhow::bail;
use std::io::Read;

use phonetic_properties::XlsxPhoneticProperties;
use phonetic_run::XlsxPhoneticRun;
use quick_xml::events::Event;
use rich_text_run::XlsxRichTextRun;

use crate::{common_types::Text, excel::XmlReader, helper::extract_text_contents};

/// Example:
/// ```
/// // shared string
/// <si>
///     <t>課きく　毛こ</t>
///     <rPh sb="0" eb="1">
///         <t>カ</t>
///     </rPh>
///     <rPh sb="4" eb="5">
///        <t>ケ</t>
///     </rPh>
///     <phoneticPr fontId="1"/>
/// </si>
/// <si>
///     <r>
///         <rPr>
///             <sz val="10" />
///             <color indexed="8" />
///             <rFont val="Helvetica Neue" />
///         </rPr>
///         <t>123</t>
///     </r>
///     <r>
///         <rPr>
///             <b val="1" />
///             <sz val="10" />
///             <color indexed="8" />
///             <rFont val="Helvetica Neue" />
///         </rPr>
///         <t>4</t>
///     </r>
/// </si>
///
/// // inline string
/// <c r="A1" t="inlineStr">
///     <is><t>This is inline string example</t></is>
/// </c>
/// ```
#[derive(Debug, Clone, PartialEq)]
pub struct XlsxStringItem {
    // Child Elements
    // phoneticPr (Phonetic Properties)	§18.4.3
    pub phonetic_properties: Option<XlsxPhoneticProperties>,
    // r (Rich Text Run)	§18.4.4
    pub rich_text_run: Option<Vec<XlsxRichTextRun>>,
    // rPh (Phonetic Run)	§18.4.6
    pub phonetic_run: Option<Vec<XlsxPhoneticRun>>,
    // t (Text)
    pub text: Option<Text>,
}

impl XlsxStringItem {
    pub(crate) fn load(reader: &mut XmlReader<impl Read>, tag: &[u8]) -> anyhow::Result<Self> {
        let mut item = Self {
            phonetic_properties: None,
            rich_text_run: None,
            phonetic_run: None,
            text: None,
        };
        let mut rich_text_runs: Vec<XlsxRichTextRun> = vec![];
        let mut phonetic_runs: Vec<XlsxPhoneticRun> = vec![];

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

            match reader.read_event_into(&mut buf) {
                Ok(Event::Start(ref e)) if e.local_name().as_ref() == b"phoneticPr" => {
                    item.phonetic_properties = Some(XlsxPhoneticProperties::load(e)?);
                }
                Ok(Event::Start(ref e)) if e.local_name().as_ref() == b"r" => {
                    rich_text_runs.push(XlsxRichTextRun::load(reader)?);
                }
                Ok(Event::Start(ref e)) if e.local_name().as_ref() == b"rPh" => {
                    phonetic_runs.push(XlsxPhoneticRun::load(reader, e)?);
                }
                Ok(Event::Start(ref e)) if e.local_name().as_ref() == b"t" => {
                    item.text = Some(extract_text_contents(reader, b"t")?);
                }
                Ok(Event::End(ref e)) if e.local_name().as_ref() == tag => break,
                Ok(Event::Eof) => bail!(
                    "unexpected end of file at `{}`.",
                    String::from_utf8(tag.to_vec()).unwrap_or("(unknown)".to_owned())
                ),
                Err(e) => bail!(e.to_string()),
                _ => (),
            }
        }
        item.phonetic_run = Some(phonetic_runs);
        item.rich_text_run = Some(rich_text_runs);

        return Ok(item);
    }
}