spreadsheet-kit 0.11.1

Core spreadsheet automation primitives — shared types, edit normalization, and session traits for agent-facing surfaces
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

use std::sync::Arc;

use anyhow::Result;
use spreadsheet_kit as spreadsheet_mcp;
use spreadsheet_mcp::model::WorkbookId;
use spreadsheet_mcp::repository::{
    VirtualWorkbookInput, VirtualWorkspaceRepository, WorkbookRepository,
};

mod support;

#[test]
fn virtual_repo_register_resolve_and_load() -> Result<()> {
    let workspace = support::TestWorkspace::new();
    let path = workspace.create_workbook("virtual_source.xlsx", |book| {
        let sheet = book.get_sheet_by_name_mut("Sheet1").unwrap();
        sheet.get_cell_mut("A1").set_value("hello");
    });

    let bytes = std::fs::read(path)?;
    let config = Arc::new(workspace.config());
    let repo = VirtualWorkspaceRepository::new(config);

    let workbook_id = repo.register(VirtualWorkbookInput {
        key: "book-1.xlsx".to_string(),
        slug: Some("book-1".to_string()),
        bytes,
    });

    let by_key = repo.resolve(&WorkbookId("book-1.xlsx".to_string()))?;
    let by_short = repo.resolve(&WorkbookId(by_key.short_id.clone()))?;
    let by_id = repo.resolve(&workbook_id)?;

    assert_eq!(by_key.workbook_id, workbook_id);
    assert_eq!(by_short.workbook_id, workbook_id);
    assert_eq!(by_id.workbook_id, workbook_id);

    let list = repo.list(&spreadsheet_mcp::tools::filters::WorkbookFilter::default())?;
    assert_eq!(list.workbooks.len(), 1);
    assert!(list.workbooks[0].revision_id.is_some());

    let ctx = repo.load_context(&by_id)?;
    assert_eq!(ctx.sheet_names(), vec!["Sheet1".to_string()]);
    Ok(())
}