edit-xlsx 0.4.4

A quick and easy-to-use Rust library for Excel file editing.
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

use std::fs;
use quick_xml::{de, se};
use crate::xml::drawings::{Drawings};

// todo: When encountering content that cannot be parsed, insert it to the file.

pub(crate) trait Insert {
    fn tag(&self) -> String;
    fn serialize_field(&self) -> String;
    fn insert(&self, content: &mut String) {
        let mut count = 1;
        let mut id = content.find(&self.tag()).unwrap_or_default();
        for c in content[id..content.len()].as_bytes() {
            id += 1;
            if *c == '<' as u8 {
                count += 1;
            } else if *c == '>' as u8 {
                count -= 1;
                println!("{c}");
                if count < 1 {
                    break;
                }
            }
        }
        content.insert_str(id, &self.serialize_field());
    }
}

impl Insert for Drawings {
    fn tag(&self) -> String {
        "xdr:wsDr".to_string()
    }

    fn serialize_field(&self) -> String {
        se::to_string_with_root("xdr:twoCellAnchor", &self.drawing).unwrap()
    }
}

// #[test]
// fn test() {
//     let xml = fs::read_to_string("tests/drawings2.txt").unwrap();
//     let drawings: Drawings = de::from_str(&xml).unwrap();
//     let mut text = fs::read_to_string("tests/drawings.txt").unwrap();
//     drawings.insert(&mut text);
//     fs::write("tests/drawings3.txt", text).unwrap();
//     // println!("{:?}", text);
// }