umya-spreadsheet 3.0.0

umya-spreadsheet is a library written in pure Rust to read and write xlsx file.
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

use quick_xml::{
    Reader,
    events::Event,
};

use crate::{
    structs::{
        Worksheet,
        raw::{
            RawFile,
            RawRelationships,
        },
        vml::Shape,
    },
    xml_read_loop,
};

pub(crate) fn read(
    worksheet: &mut Worksheet,
    drawing_file: &RawFile,
    drawing_relationships: Option<&RawRelationships>,
) {
    let data = std::io::Cursor::new(drawing_file.file_data());
    let mut reader = Reader::from_reader(data);
    reader.config_mut().trim_text(true);

    let mut ole_index = 0;
    let mut comment_index = 0;

    xml_read_loop!(
        reader,
            Event::Start(ref e) => {
                if e.name().into_inner() == b"v:shape" {
                    let mut obj = Shape::default();
                    obj.set_attributes(&mut reader, e, drawing_relationships);
                    if obj.client_data().comment_column_target().is_some() {
                        worksheet
                            .comments_mut()
                            .get_mut(comment_index)
                            .map(|comment| comment.set_shape(obj));
                        comment_index += 1;
                    } else {
                        worksheet
                            .ole_objects_mut()
                            .ole_object_mut()
                            .get_mut(ole_index)
                            .map(|ole_obj| ole_obj.set_shape(obj));
                        ole_index += 1;
                    }
                }
            },
            Event::Eof => break,
    );
}

// fn set_style(comment:&mut Comment, style_string:&str) {
//    let styles: Vec<&str> = style_string.split(';').collect();
//    for style in &styles {
//        let params: Vec<&str> = style.split(':').collect();
//        if params.len() == 2 {
//            let key_string = params[0].replace(" ", "").replace("\r\n", "");
//            let key = key_string.as_str();
//            let value = params[1].replace(" ", "").replace("\r\n", "");
//            match key {
//                "margin-left" => comment.set_margin_left(value),
//                "margin-top" => comment.set_margin_top(value),
//                "width" => comment.set_width(value),
//                "height" => comment.set_height(value),
//                "visibility" => comment.set_visible(if value == "visible" {
// true } else { false }),                _ => {}
//            }
//        }
//    }
//}