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

use excel_add_sheet::{ExcelDoc, ExcelWorkbook};

fn main() -> Result<(), Box<dyn std::error::Error>> {
    // 1. Open the Excel file
    let mut doc = ExcelDoc::open("minimal.xlsx")?;

    // 2. Add a new worksheet with some data
    let data = vec![
        vec!["Hello".to_string(), "World".to_string()],
        vec!["123".to_string(), "456".to_string()],
    ];
    doc.add_worksheet("NewSheet", Some(data))?;

    // 3. Save as a new file
    doc.save("modified.xlsx")?;

    println!("Added worksheet and saved as modified.xlsx!");

    Ok(())
}