ironcalc 0.7.1

The democratization of spreadsheets
Documentation 
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

use std::io::Read;

use ironcalc_base::types::Metadata;

use crate::error::XlsxError;

use super::util::get_value_or_default;

struct AppData {
    application: String,
    app_version: String,
}

struct CoreData {
    creator: String,
    last_modified_by: String,
    created: String,
    last_modified: String,
}

fn load_core<R: Read + std::io::Seek>(
    archive: &mut zip::read::ZipArchive<R>,
) -> Result<CoreData, XlsxError> {
    let mut file = archive.by_name("docProps/core.xml")?;
    let mut text = String::new();
    file.read_to_string(&mut text)?;
    let doc = roxmltree::Document::parse(&text)?;
    let core_data = doc
        .root()
        .first_child()
        .ok_or_else(|| XlsxError::Xml("Corrupt XML structure".to_string()))?;
    // Note the namespace should be "http://purl.org/dc/elements/1.1/"
    let creator = get_value_or_default(&core_data, "creator", "Anonymous User");
    // Note namespace is "http://schemas.openxmlformats.org/package/2006/metadata/core-properties"
    let last_modified_by = get_value_or_default(&core_data, "lastModifiedBy", "Anonymous User");
    // In these two cases the namespace is "http://purl.org/dc/terms/"
    let created = get_value_or_default(&core_data, "created", "");
    let last_modified = get_value_or_default(&core_data, "modified", "");

    Ok(CoreData {
        creator,
        last_modified_by,
        created,
        last_modified,
    })
}

fn load_app<R: Read + std::io::Seek>(
    archive: &mut zip::read::ZipArchive<R>,
) -> Result<AppData, XlsxError> {
    let mut file = archive.by_name("docProps/app.xml")?;
    let mut text = String::new();
    file.read_to_string(&mut text)?;
    let doc = roxmltree::Document::parse(&text)?;
    let app_data = doc
        .root()
        .first_child()
        .ok_or_else(|| XlsxError::Xml("Corrupt XML structure".to_string()))?;

    let application = get_value_or_default(&app_data, "Application", "Unknown application");
    let app_version = get_value_or_default(&app_data, "AppVersion", "");
    Ok(AppData {
        application,
        app_version,
    })
}

pub(super) fn load_metadata<R: Read + std::io::Seek>(
    archive: &mut zip::read::ZipArchive<R>,
) -> Result<Metadata, XlsxError> {
    let app_data = load_app(archive)?;
    let core_data = load_core(archive)?;
    Ok(Metadata {
        application: app_data.application,
        app_version: app_data.app_version,
        creator: core_data.creator,
        last_modified_by: core_data.last_modified_by,
        created: core_data.created,
        last_modified: core_data.last_modified,
    })
}