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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73

use serde::{Deserialize, Serialize};
use crate::xml::common;
use crate::xml::style::color::Color;

#[derive(Debug, Clone, Deserialize, Serialize)]
pub(crate) struct Borders {
    #[serde(rename = "@count", default, skip_serializing_if = "common::is_zero")]
    count: u32,
    border: Vec<Border>,
}

impl Borders {
    pub(crate) fn add_border(&mut self, border: &Border) -> u32 {
        for i in 0..self.border.len() {
            if self.border[i] == *border {
                return i as u32;
            }
        }
        self.count += 1;
        self.border.push(border.clone());
        self.border.len() as u32 - 1
    }

    pub(crate) fn get_border(&self, id: u32) -> Option<&Border> {
        self.border.get(id as usize)
    }
}

#[derive(Debug, Deserialize, Serialize, Clone, PartialEq, Default)]
pub(crate) struct Border {
    #[serde(rename = "@diagonalUp", skip_serializing_if = "Option::is_none")]
    pub(crate) diagonal_up: Option<u8>,
    #[serde(rename = "@diagonalDown", skip_serializing_if = "Option::is_none")]
    pub(crate) diagonal_down: Option<u8>,
    #[serde(rename = "@outline", skip_serializing_if = "Option::is_none")]
    pub(crate) outline: Option<u8>,
    #[serde(rename = "left", skip_serializing_if = "Option::is_none")]
    pub(crate) left: Option<BorderElement>,
    #[serde(rename = "right", skip_serializing_if = "Option::is_none")]
    pub(crate) right: Option<BorderElement>,
    #[serde(rename = "top", skip_serializing_if = "Option::is_none")]
    pub(crate) top: Option<BorderElement>,
    #[serde(rename = "bottom", skip_serializing_if = "Option::is_none")]
    pub(crate) bottom: Option<BorderElement>,
    #[serde(rename = "diagonal", skip_serializing_if = "Option::is_none")]
    pub(crate) diagonal: Option<BorderElement>,
}

#[derive(Debug, Deserialize, Serialize, Clone, PartialEq)]
pub(crate) struct BorderElement {
    #[serde(rename = "@style", skip_serializing_if = "Option::is_none")]
    pub(crate) style: Option<String>,
    #[serde(skip_serializing_if = "Option::is_none")]
    pub(crate) color: Option<Color>,
}

impl Default for BorderElement {
    fn default() -> Self {
        BorderElement {
            style: None,
            color: Some(Color::default()),
        }
    }
}

impl Default for Borders {
    fn default() -> Self {
        Borders {
            count: 0,
            border: vec![],
        }
    }
}