qwitlib 0.4.0

A library for dsv files
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

use crate::from_excel::operators::count_columns;
use crate::{
    core::{CsvError, CsvRow, CsvRowOperator, CsvValue},
    epoch_conversion::ExcelEpoch,
};
use calamine::{Data, Range};

pub mod operators;

pub fn write_range(
    range: &Range<Data>,
    mut operator: impl CsvRowOperator,
    line_length: i32,
    sep: String,
) -> Result<(), CsvError> {
    let all_rows = range.rows().map(CsvRow::iterator);
    operator.operate(sep, line_length, all_rows)
}

pub fn get_max_line_length_of_first_x_lines(
    range: &Range<Data>,
    lines_to_consider: i32,
) -> Result<i32, CsvError> {
    let all_rows = range.rows().map(CsvRow::iterator);
    count_columns(lines_to_consider, all_rows)
}

#[allow(clippy::cast_possible_truncation)]
impl From<Data> for CsvValue {
    fn from(value: Data) -> Self {
        match value {
            // we do nothing on empty
            Data::Empty => CsvValue(Err("Empty Value".to_owned())),
            // we write for those types
            Data::String(ref s) | Data::DateTimeIso(ref s) | Data::DurationIso(ref s) => {
                // surround strings with '"' to handle separator inside
                let escaped = format!(r#""{}""#, s);
                CsvValue(Ok(escaped))
            }

            Data::DateTime(ref f) => {
                let as_int = f.as_f64().round() as i64;
                let epoch = ExcelEpoch(as_int);
                let as_string = epoch.to_string();
                CsvValue(Ok(as_string))
            }

            // we also just write for those
            Data::Float(ref f) => CsvValue(Ok(f.to_string())),
            Data::Int(ref i) => CsvValue(Ok(i.to_string())),
            Data::Bool(ref b) => CsvValue(Ok(b.to_string())),
            Data::Error(ref e) => CsvValue(Err(format!(
                "error in sheet, fix or remove cell error: {e}"
            ))),
        }
    }
}