spreadsheet-mcp 0.10.1

Stateful MCP server for spreadsheet analysis and editing — token-efficient tools for LLM agents to read, profile, edit, and recalculate .xlsx workbooks
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

#[cfg(feature = "recalc")]
mod backend;
#[cfg(feature = "recalc")]
mod executor;
#[cfg(feature = "recalc-libreoffice")]
mod fire_and_forget;
#[cfg(feature = "recalc-formualizer")]
mod formualizer_backend;
#[cfg(feature = "recalc")]
pub mod macro_uri;
#[cfg(feature = "recalc-libreoffice")]
mod pooled;
#[cfg(feature = "recalc-libreoffice")]
mod screenshot;

#[cfg(feature = "recalc-libreoffice")]
pub use backend::LibreOfficeBackend;
#[cfg(feature = "recalc")]
pub use backend::RecalcBackend;
#[cfg(feature = "recalc-libreoffice")]
pub use executor::RecalcExecutor;
#[cfg(feature = "recalc")]
pub use executor::RecalcResult;
#[cfg(feature = "recalc-libreoffice")]
pub use fire_and_forget::FireAndForgetExecutor;
#[cfg(feature = "recalc-formualizer")]
pub use formualizer_backend::FormualizerBackend;
#[cfg(feature = "recalc-libreoffice")]
pub use screenshot::{ScreenshotExecutor, ScreenshotResult};

use std::path::PathBuf;
#[cfg(feature = "recalc")]
use std::sync::Arc;
#[cfg(feature = "recalc")]
use tokio::sync::Semaphore;

#[cfg(feature = "recalc")]
#[derive(Clone)]
pub struct GlobalRecalcLock(pub Arc<Semaphore>);

#[cfg(feature = "recalc")]
impl GlobalRecalcLock {
    pub fn new(permits: usize) -> Self {
        Self(Arc::new(Semaphore::new(permits)))
    }
}

#[cfg(feature = "recalc")]
#[derive(Clone)]
pub struct GlobalScreenshotLock(pub Arc<Semaphore>);

#[cfg(feature = "recalc")]
impl GlobalScreenshotLock {
    pub fn new() -> Self {
        Self(Arc::new(Semaphore::new(1)))
    }
}

#[cfg(feature = "recalc")]
impl Default for GlobalScreenshotLock {
    fn default() -> Self {
        Self::new()
    }
}

#[derive(Debug, Clone, Copy, Default)]
pub enum ExecutorStrategy {
    #[default]
    FireAndForget,
    Pooled,
}

#[derive(Debug, Clone)]
pub struct RecalcConfig {
    pub soffice_path: Option<PathBuf>,
    pub timeout_ms: Option<u64>,
    pub strategy: ExecutorStrategy,
}

impl Default for RecalcConfig {
    fn default() -> Self {
        Self {
            soffice_path: None,
            timeout_ms: Some(30_000),
            strategy: ExecutorStrategy::FireAndForget,
        }
    }
}

#[cfg(feature = "recalc-libreoffice")]
pub fn create_executor(config: &RecalcConfig) -> Arc<dyn RecalcExecutor> {
    match config.strategy {
        ExecutorStrategy::FireAndForget => Arc::new(FireAndForgetExecutor::new(config)),
        ExecutorStrategy::Pooled => {
            tracing::warn!("Pooled executor not yet implemented, falling back to fire-and-forget");
            Arc::new(FireAndForgetExecutor::new(config))
        }
    }
}