excel_add_sheet 0.1.0

A library for adding worksheets to existing Excel (XLSX) files.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

use excel_add_sheet::ExcelDoc;

fn main() -> Result<(), Box<dyn std::error::Error>> {
    let minimal = r"C:\Users\Joey\Desktop\Rust apps\SoL\sol_check\uploaded_edited.xlsx";

    // Open the original file
    let mut doc = ExcelDoc::open(minimal)?;

    // Add a new worksheet with some sample data
    let data = vec![
        vec!["Scripted".to_string(), "Sheet".to_string()],
        vec!["123".to_string(), "456".to_string()],
    ];
    doc.add_worksheet("ScriptSheet", Some(data))?;

    // Save back to the same file (overwrite)
    doc.save(minimal)?;

    println!("Added ScriptSheet and saved to minimal.xlsx!");
    Ok(())
}