umya-spreadsheet 2.3.3

umya-spreadsheet is a library written in pure Rust to read and write xlsx file.
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

use crate::helper::coordinate::*;

use super::coordinate;

/// `(col, row)`
pub type BasicCellIndex = (u32, u32);

/// # Returns
/// `Vec<(col, row)>`
pub fn get_coordinate_list(range_str: &str) -> Vec<BasicCellIndex> {
    let (row_start, row_end, col_start, col_end) = get_start_and_end_point(range_str);

    (row_start..=row_end)
        .flat_map(|row_num| (col_start..=col_end).map(move |col_num| (col_num, row_num)))
        .collect()
}

pub fn get_start_and_end_point(range_str: &str) -> (u32, u32, u32, u32) {
    let upper_rng_str = range_str.to_uppercase();
    let coordinate_collection: Vec<&str> = upper_rng_str.split(':').collect();

    assert!(
        matches!(coordinate_collection.len(), 1 | 2),
        "Non-standard range."
    );

    let mut is_col_select = false;
    let mut is_row_select = false;
    let (mut col_start, mut col_end, mut row_start, mut row_end) = (0, 0, 0, 0);

    let (col, row, ..) = index_from_coordinate(coordinate_collection[0]);

    if let Some(v) = col {
        is_col_select = true;
        col_start = v;
        col_end = v;
    }

    if let Some(v) = row {
        is_row_select = true;
        row_start = v;
        row_end = v;
    }

    if coordinate_collection.len() == 2 {
        let (col, row, ..) = index_from_coordinate(coordinate_collection[1]);

        match col {
            Some(v) => {
                col_end = v;
            }
            None => {
                assert!(is_col_select, "Non-standard range.");
            }
        };

        match row {
            Some(v) => {
                row_end = v;
            }
            None => {
                assert!(is_row_select, "Non-standard range.");
            }
        }
    }

    (row_start, row_end, col_start, col_end)
}

#[inline]
pub fn get_split_range(range: &str) -> Vec<&str> {
    range.split(':').collect()
}

#[inline]
pub fn get_join_range(coordinate_list: &[String]) -> String {
    coordinate_list.join(":")
}