rxlsb 0.2.0

Pure Rust XLSB (Excel Binary Workbook) reader/writer library
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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108

use crate::io::BufferWriter;
use crate::format::RecordType;
use bytes::Bytes;
use crate::error::Result;

pub struct WorkbookWriter {
    sheets: Vec<String>,
}

impl WorkbookWriter {
    pub fn new() -> Self {
        Self { sheets: vec![] }
    }
    
    pub fn add_sheet(&mut self, name: &str) {
        self.sheets.push(name.to_string());
    }
    
    pub fn sheet_count(&self) -> usize {
        self.sheets.len()
    }
    
    pub fn serialize(&self) -> Result<Bytes> {
        let mut writer = BufferWriter::new(256);
        
        writer.write_varint(RecordType::BrtBeginBook.to_u32());
        writer.write_varsize(0);
        
        self.write_brt_file_version(&mut writer);
        self.write_brt_wb_prop(&mut writer);
        
        writer.write_varint(RecordType::BrtBeginBookViews.to_u32());
        writer.write_varsize(0);
        
        self.write_brt_book_view(&mut writer);
        
        writer.write_varint(RecordType::BrtEndBookViews.to_u32());
        writer.write_varsize(0);
        
        writer.write_varint(RecordType::BrtBeginBundleShs.to_u32());
        writer.write_varsize(0);
        
        for (i, sheet_name) in self.sheets.iter().enumerate() {
            let rel_id = format!("rId{}", i + 1);
            let rel_id_chars = rel_id.encode_utf16().count();
            let name_chars = sheet_name.encode_utf16().count();
            
            let rel_id_size = 4 + rel_id_chars * 2;
            let name_size = 4 + name_chars * 2;
            
            writer.write_varint(RecordType::BrtBundleSh.to_u32());
            writer.write_varsize((8 + rel_id_size + name_size) as u32);
            writer.write_u32_le(0);
            writer.write_u32_le(i as u32 + 1);
            
            writer.write_u32_le(rel_id_chars as u32);
            for ch in rel_id.encode_utf16() {
                writer.write_u16_le(ch);
            }
            
            writer.write_u32_le(name_chars as u32);
            for ch in sheet_name.encode_utf16() {
                writer.write_u16_le(ch);
            }
        }
        
        writer.write_varint(RecordType::BrtEndBundleShs.to_u32());
        writer.write_varsize(0);
        
        writer.write_varint(RecordType::BrtEndBook.to_u32());
        writer.write_varsize(0);
        
        Ok(writer.freeze())
    }
    
    fn write_brt_file_version(&self, writer: &mut BufferWriter) {
        writer.write_varint(128);
        writer.write_varsize(47);
        writer.write_bytes(&[
            0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00,
            0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x02, 0x00,
            0x00, 0x00, 0x78, 0x00, 0x6c, 0x00, 0x01, 0x00,
            0x00, 0x00, 0x33, 0x00, 0x01, 0x00, 0x00, 0x00,
            0x35, 0x00, 0x04, 0x00, 0x00, 0x00, 0x39, 0x00,
            0x33, 0x00, 0x30, 0x00, 0x32, 0x00, 0x00
        ]);
    }
    
    fn write_brt_wb_prop(&self, writer: &mut BufferWriter) {
        writer.write_varint(153);
        writer.write_varsize(12);
        writer.write_bytes(&[
            0x20, 0x00, 0x01, 0x00, 0x00, 0x00, 0x00, 0x00,
            0x00, 0x00, 0x00, 0x00
        ]);
    }
    
    fn write_brt_book_view(&self, writer: &mut BufferWriter) {
        writer.write_varint(158);
        writer.write_varsize(29);
        writer.write_bytes(&[
            0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00,
            0x80, 0x70, 0x00, 0x00, 0xcf, 0x30, 0x00, 0x00,
            0x58, 0x02, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00,
            0x00, 0x00, 0x00, 0x00, 0x78
        ]);
    }
}