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
use std::rc::Rc;
use crate::api::cell::location::Location;
use crate::{Cell, Format, WorkSheet, WorkSheetResult};
use crate::api::cell::values::{CellDisplay, CellType, CellValue};
use crate::api::worksheet::format::_Format;
use crate::xml::shared_string::SharedString;
pub trait Read: _Read {
fn read_cell<L: Location>(&self, loc: L) -> WorkSheetResult<Cell<String>> {
self.read_api_cell(&loc)
}
// fn read_text<L: Location>(&self, loc: L) -> WorkSheetResult<&str> { self.read_value(loc) }
// fn read_string<L: Location>(&self, loc: L) -> WorkSheetResult<&str> { self.read_value(loc) }
// fn read_shared_string<L: Location>(&self, loc: L) -> WorkSheetResult<&str> { self.read_value(loc) }
// fn read_url<L: Location>(&self, loc: L) -> WorkSheetResult<&str> { Ok("") }
// fn read_format<L: Location>(&self, loc: L) -> WorkSheetResult<Format> {self.read_format_all(loc)}
}
trait _Read {
fn read_api_cell<L: Location>(&self, loc: &L) -> WorkSheetResult<Cell<String>>;
// fn get_cell_type<L: Location>(&self, loc: L) -> WorkSheetResult<&CellType>;
// fn read_value<L: Location>(&self, loc: L) -> WorkSheetResult<&str>;
// fn read_text<L: Location>(&self, loc: L) -> WorkSheetResult<&str>;
// fn read_format_all<L: Location>(&self, loc: L) -> WorkSheetResult<Format>;
}
impl _Read for WorkSheet {
fn read_api_cell<L: Location>(&self, loc: &L) -> WorkSheetResult<Cell<String>> {
let mut cell = self.worksheet.sheet_data.read_api_cell(loc)?;
if let Some(style) = cell.style {
cell.format = Some(self.get_format(style));
}
if let Some(CellType::SharedString) = cell.cell_type {
let id: usize = if let Some(s) = &cell.text {
s.parse().unwrap_or_default()
} else { 0 };
if let Some(rich_text) = self.shared_string.get_rich_text(id) {
cell.cell_type = Some(CellType::InlineString);
cell.rich_text = Some(rich_text);
} else if let Some(text) = self.shared_string.get_text(id) {
cell.cell_type = Some(CellType::String);
cell.text = Some(text.to_string());
} else {
cell.cell_type = Some(CellType::String);
cell.text = Some(String::new());
}
};
cell.hyperlink = self.worksheet.get_hyperlink(loc);
Ok(cell)
}
// fn get_cell_type<L: Location>(&self, loc: L) -> WorkSheetResult<&CellType> {
// let worksheet = &self.worksheet;
// let sheet_data = &worksheet.sheet_data;
// let cell_type = sheet_data.get_cell_type(&loc);
// cell_type.ok_or(WorkSheetError::RowError(RowError::CellError(CellError::CellNotFound)))
// }
// fn read_value<L: Location>(&self, loc: L) -> WorkSheetResult<&str> {
// let worksheet = &self.worksheet;
// let sheet_data = &worksheet.sheet_data;
// let cell_type = sheet_data.get_cell_type(&loc);
// let value = sheet_data.get_value(&loc);
// let text = match cell_type {
// Some(CellType::SharedString) => {
// let id: usize = value.unwrap_or("0").parse().unwrap();
// self.shared_string.get_text(id)
// },
// _ => value
// };
// text.ok_or(WorkSheetError::RowError(RowError::CellError(CellError::CellNotFound)))
// }
// fn read_text<L: Location>(&self, loc: L) -> WorkSheetResult<&str> {
// let worksheet = &self.worksheet;
// let sheet_data = &worksheet.sheet_data;
// let value = sheet_data.get_value(&loc);
// let cell_type = sheet_data.get_cell_type(&loc);
// match cell_type {
// Some(CellType::SharedString) => {
// Ok("SharedString")
// }
// _ => {
// value.ok_or(WorkSheetError::RowError(RowError::CellError(CellError::CellNotFound)))
// }
// }
// }
// fn read_format_all<L: Location>(&self, loc: L) -> WorkSheetResult<Format> {
// let worksheet = &self.worksheet;
// // let sheet_data = &worksheet.sheet_data;
// match worksheet.get_default_style(&loc) {
// Some(style) => Ok(self.get_format(style)),
// None => Err(WorkSheetError::FileNotFound)
// }
// }
}