edit-xlsx 0.4.6

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
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
109
110
111
112
113
114
115
116
117

use std::fs::File;
use std::{fs, io};
use std::io::{Read, Write};
use std::path::{Path, PathBuf};

pub enum XlsxFileType {
    WorkbookFile,
    SheetFile(String),
    SharedStringFile,
    StylesFile,
    WorkbookRels,
    WorksheetRels(u32),
    ContentTypes,
    Medias(String),
    Drawings(u32),
    DrawingRels(u32),
    VmlDrawings(u32),
    Comments(u32),
    MetaData,
    CoreProperties,
    AppProperties,
}
pub struct XlsxFileWriter {
    file_type: XlsxFileType,
    file_path: PathBuf,
    pub(crate) file: File,
}

impl XlsxFileWriter {
    pub(crate) fn from_path<P: AsRef<Path>>(base_path: P, file_type: XlsxFileType) -> io::Result<XlsxFileWriter> {
        let file_path = file_type.get_path(&base_path);
        Ok(XlsxFileWriter {
            file: {
                Self::mkdir(&base_path, &file_type)?;
                File::create(&file_path)?
            },
            file_type,
            file_path,
        })
    }

    pub(crate) fn read_from<P: AsRef<Path>>(base_path: P, file_type: XlsxFileType, content: &mut String) -> io::Result<()> {
        let file_path = file_type.get_path(&base_path);
        *content = fs::read_to_string(file_path).unwrap_or_default();
        Ok(())
    }

    fn mkdir<P: AsRef<Path>>(base_path: P, file_type: &XlsxFileType) -> io::Result<()> {
        let file_path = file_type.get_path(base_path);
        let mut dirs = file_path.clone();
        dirs.pop();
        fs::create_dir_all(&dirs).unwrap_or_else(|_| {});
        Ok(())
    }

    pub(crate) fn write_all(&mut self, buf: &[u8]) -> io::Result<()> {
        self.file.write_all(buf)
    }

    pub(crate) fn copy_from<P, Q>(base_path: P, file_type: XlsxFileType, from: Q) -> io::Result<()>
        where P: AsRef<Path>,
              Q: AsRef<Path>
    {
        let file_path = file_type.get_path(&base_path);
        Self::mkdir(&base_path, &file_type)?;
        if from.as_ref().to_path_buf() == file_path.to_path_buf() {
            return Ok(())
        }
        fs::copy(from, file_path)?;
        Ok(())
    }
}

impl XlsxFileType {
    fn get_dir(&self) -> &str {
        match self {
            XlsxFileType::WorkbookFile | XlsxFileType::SharedStringFile
            | XlsxFileType::StylesFile | XlsxFileType::MetaData
            | XlsxFileType::Comments(_) => "./xl",

            XlsxFileType::SheetFile(_) => "./xl",
            XlsxFileType::WorkbookRels => "./xl/_rels",
            XlsxFileType::WorksheetRels(_) => "./xl/worksheets/_rels",
            XlsxFileType::ContentTypes => ".",
            XlsxFileType::Medias(_) => "./xl/media",
            XlsxFileType::Drawings(_) | XlsxFileType::VmlDrawings(_) => "./xl/drawings",
            XlsxFileType::DrawingRels(_) => "./xl/drawings/_rels",
            XlsxFileType::CoreProperties | XlsxFileType::AppProperties => "./docProps",
        }
    }
    fn get_filename(&self) -> String {
        match self {
            XlsxFileType::WorkbookFile => "workbook.xml".to_string(),
            // XlsxFileType::SheetFile(id) => format!("sheet{id}.xml"),
            XlsxFileType::SheetFile(target) => format!("{target}"), //format!("sheet{id}.xml"),
            XlsxFileType::SharedStringFile => "sharedStrings.xml".to_string(),
            XlsxFileType::StylesFile => "styles.xml".to_string(),
            XlsxFileType::WorkbookRels => "workbook.xml.rels".to_string(),
            XlsxFileType::WorksheetRels(id) => format!("sheet{id}.xml.rels"),
            XlsxFileType::ContentTypes => "[Content_Types].xml".to_string(),
            XlsxFileType::Medias(name) => format!("{name}"),
            XlsxFileType::Drawings(id) => format!("drawing{id}.xml"),
            XlsxFileType::VmlDrawings(id) => format!("vmlDrawing{id}.vml"),
            XlsxFileType::DrawingRels(id) => format!("drawing{id}.xml.rels"),
            XlsxFileType::MetaData => "metadata.xml".to_string(),
            XlsxFileType::CoreProperties => "core.xml".to_string(),
            XlsxFileType::AppProperties => "app.xml".to_string(),
            XlsxFileType::Comments(id) => format!("comments{id}.xml"),
        }
    }
    pub(crate) fn get_path<P: AsRef<Path>>(&self, base_path: P) -> PathBuf {
        base_path.as_ref().join(self.get_dir()).join(self.get_filename())
    }
    pub(crate) fn get_relative_path(&self) -> String {
        format!("{}/{}", self.get_dir(), self.get_filename())
    }
}