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
use std::path::Path;
use json::{JsonValue, object};
use umya_spreadsheet::{new_file, Spreadsheet, writer};
use crate::Head;
pub struct Write {
path: String,
page: usize,
excel: Spreadsheet,
}
impl Write {
pub fn new(filepath: &str) -> Self {
let book = new_file();
Self {
path: filepath.to_string(),
page: 0,
excel: book,
}
}
pub fn set_page(&mut self, page: usize, name: &str, headers: Vec<Head>, data: JsonValue) -> &mut Self {
self.page = page - 1;
if self.page > 0 {
self.excel.new_sheet(name).unwrap();
}
self.excel.get_sheet_mut(&self.page).unwrap().set_name(name);
let mut row_line = 1;
let mut col_line = 1;
let mut header_key_value = object! {};
for header in headers.iter() {
self.excel.get_sheet_mut(&self.page).unwrap().get_cell_mut((col_line, row_line)).set_value_string(header.clone().title);
header_key_value[header.clone().field] = JsonValue::from(col_line);
col_line += 1;
}
for row in data.members() {
row_line += 1;
for (key, value) in row.entries() {
col_line = header_key_value[key].as_u32().unwrap();
self.excel.get_sheet_mut(&self.page).unwrap().get_cell_mut((col_line, row_line)).set_value_string(value.to_string().clone());
}
}
self
}
pub fn save(&mut self) -> bool {
let path = Path::new(self.path.as_str().clone());
match writer::xlsx::write(&self.excel, path) {
Ok(_) => true,
Err(_) => false
}
}
}