edit-xlsx 0.4.4

A quick and easy-to-use Rust library for Excel file editing.
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

use serde::{Deserialize, Serialize};
use crate::api::cell::location::Location;

#[derive(Debug, Clone, Deserialize, Serialize, Default)]
pub(crate) struct Hyperlinks {
    #[serde(rename = "hyperlink")]
    hyperlink: Vec<Hyperlink>
}

impl Hyperlinks {
    pub(crate) fn add_hyperlink<L: Location>(&mut self, loc: &L, r_id: u32) {
        let hyperlink = Hyperlink::new(&loc.to_ref(), r_id);
        self.hyperlink.push(hyperlink)
    }

    pub(crate) fn get_hyperlink<L: Location>(&self, loc: &L) -> Option<String> {
        let loc = loc.to_ref();
        let h = self.hyperlink.iter()
            .filter(|h| loc == h.hyperlink_ref)
            .last();
        match h {
            None => None,
            Some(h) => h.display.clone()
        }
    }
}

#[derive(Debug, Clone, Deserialize, Serialize)]
struct Hyperlink {
    #[serde(rename = "@ref")]
    hyperlink_ref: String,
    #[serde(rename = "@location", skip_serializing_if = "Option::is_none")]
    location: Option<String>,
    #[serde(rename(serialize = "@r:id", deserialize = "@id"), skip_serializing_if = "Option::is_none")]
    r_id: Option<String>,
    #[serde(rename = "@display", skip_serializing_if = "Option::is_none")]
    display: Option<String>,
    #[serde(rename = "@tooltip", skip_serializing_if = "Option::is_none")]
    tooltip: Option<String>,
    #[serde(rename(serialize = "@xr:uid", deserialize = "@uid"), default, skip_serializing_if = "String::is_empty")]
    uid: String,
}

impl Hyperlink {
    fn new(hyperlink_ref: &str, r_id: u32) -> Self {
        Self {
            hyperlink_ref: String::from(hyperlink_ref),
            location: None,
            display: None,
            tooltip: None,
            r_id: Some(format!("rId{r_id}")),
            uid: "".to_string(),
        }
    }
}