excelx 0.4.0

Type-safe XLSX read/write helpers for Rust structs.
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
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103

use calamine::Data;

use crate::ExcelError;

/// A small, explicit value model for the cell types supported in Phase 1.
#[derive(Clone, Debug, PartialEq)]
pub enum CellValue {
    String(String),
    Int(i64),
    Float(f64),
    Bool(bool),
    Empty,
}

impl CellValue {
    pub fn type_name(&self) -> &'static str {
        match self {
            Self::String(_) => "string",
            Self::Int(_) => "integer",
            Self::Float(_) => "float",
            Self::Bool(_) => "boolean",
            Self::Empty => "empty",
        }
    }

    pub fn is_empty(&self) -> bool {
        matches!(self, Self::Empty)
    }
}

impl From<&str> for CellValue {
    fn from(value: &str) -> Self {
        Self::String(value.to_owned())
    }
}

impl From<String> for CellValue {
    fn from(value: String) -> Self {
        Self::String(value)
    }
}

impl From<i64> for CellValue {
    fn from(value: i64) -> Self {
        Self::Int(value)
    }
}

impl From<i32> for CellValue {
    fn from(value: i32) -> Self {
        Self::Int(i64::from(value))
    }
}

impl From<u32> for CellValue {
    fn from(value: u32) -> Self {
        Self::Int(i64::from(value))
    }
}

impl From<f64> for CellValue {
    fn from(value: f64) -> Self {
        Self::Float(value)
    }
}

impl From<f32> for CellValue {
    fn from(value: f32) -> Self {
        Self::Float(f64::from(value))
    }
}

impl From<bool> for CellValue {
    fn from(value: bool) -> Self {
        Self::Bool(value)
    }
}

impl TryFrom<&Data> for CellValue {
    type Error = ExcelError;

    fn try_from(value: &Data) -> Result<Self, Self::Error> {
        match value {
            Data::String(value) => Ok(Self::String(value.clone())),
            Data::Int(value) => Ok(Self::Int(*value)),
            Data::Float(value) => Ok(Self::Float(*value)),
            Data::Bool(value) => Ok(Self::Bool(*value)),
            Data::Empty => Ok(Self::Empty),
            Data::DateTime(value) => Err(ExcelError::Parse(format!(
                "unsupported date/time cell value: {value}"
            ))),
            Data::DateTimeIso(value) => Err(ExcelError::Parse(format!(
                "unsupported ISO date/time cell value: {value}"
            ))),
            Data::DurationIso(value) => Err(ExcelError::Parse(format!(
                "unsupported ISO duration cell value: {value}"
            ))),
            Data::Error(value) => Err(ExcelError::Parse(format!(
                "cell contains Excel error: {value}"
            ))),
        }
    }
}