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

use crate::utils::col_helper;

#[derive(Default, Debug, Copy, Clone)]
struct CellAddressRange {
    first_row: u32,
    first_col: u32,
    last_row: u32,
    last_col: u32,
}

impl CellAddressRange {
    fn new(first_row: u32, first_col: u32, last_row: u32, last_col: u32) -> CellAddressRange {
        CellAddressRange {
            first_row,
            first_col,
            last_row,
            last_col,
        }
    }

    fn from_str(refer: &str) -> CellAddressRange {
        let mut cell_address_range = CellAddressRange::default();
        let cell_addresses: Vec<&str> = refer.split(":").collect();
        match cell_addresses.len() {
            1 => {
                (cell_address_range.first_row, cell_address_range.first_col) =
                    col_helper::to_loc(cell_addresses[0]);
                (cell_address_range.last_row, cell_address_range.last_col) =
                    (cell_address_range.first_row, cell_address_range.first_col)
            },
            2 => {
                (cell_address_range.first_row, cell_address_range.first_col) =
                    col_helper::to_loc(cell_addresses[0]);
                (cell_address_range.last_row, cell_address_range.last_col) =
                    col_helper::to_loc(cell_addresses[1]);
            },
            _ => {}
        }
        cell_address_range
    }

    fn to_string(&self) -> String {
        todo!()
        // return the string like A1:B2 format
    }

    fn to_cell_address_string(&self) -> String {
        todo!()
        // just return the start address string like A1 format
    }
}