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

use crate::utils::col_helper;

#[derive(Default, Debug, Copy, Clone)]
pub(crate) struct CellReference {
    row: u32,
    col: u32,
    abs_row: bool,
    abs_col: bool,
}

impl CellReference {
    fn new(row: u32, col: u32, abs_row: bool, abs_col: bool) -> CellReference {
        CellReference {
            row,
            col,
            abs_row,
            abs_col,
        }
    }
    fn from_str(refer: &str) -> CellReference {
        let mut coord = CellReference::default();
        let mut row = String::new();
        let mut col = String::new();
        let mut dollar = None;
        for c in refer.chars() {
            match c {
                '$' => { let _ = dollar.insert(1); },
                'A'..='Z' | 'a'..='z' => {
                    col.push(c);
                    if dollar.take().is_some() {
                        coord.abs_col = true;
                    }
                },
                '0'..='9' => {
                    row.push(c);
                    if dollar.take().is_some() {
                        coord.abs_row = true;
                    }
                },
                _ => {},
            }
        }
        coord.row = row.parse().unwrap_or_default();
        coord.col = col_helper::to_col(&col);
        coord
    }
    fn to_string(&self) -> String {
        let mut refer = String::new();
        if self.abs_col {
            refer.push('$')
        }
        refer.push_str(&col_helper::to_col_name(self.col));
        if self.abs_row {
            refer.push('$')
        }
        refer.push_str(&self.row.to_string());
        refer
    }
}