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

use anyhow::{Result, anyhow};
use globset::{Glob, GlobMatcher};
use std::path::Path;

#[derive(Default)]
pub struct WorkbookFilter {
    slug_prefix: Option<String>,
    folder: Option<String>,
    path_glob: Option<GlobMatcher>,
}

impl WorkbookFilter {
    pub fn new(
        slug_prefix: Option<String>,
        folder: Option<String>,
        path_glob: Option<String>,
    ) -> Result<Self> {
        let matcher = if let Some(glob) = path_glob {
            Some(
                Glob::new(&glob)
                    .map_err(|err| anyhow!("invalid glob pattern {glob}: {err}"))?
                    .compile_matcher(),
            )
        } else {
            None
        };

        Ok(Self {
            slug_prefix: slug_prefix.map(|s| s.to_ascii_lowercase()),
            folder: folder.map(|s| s.to_ascii_lowercase()),
            path_glob: matcher,
        })
    }

    pub fn matches(&self, slug: &str, folder: Option<&str>, path: &Path) -> bool {
        if let Some(prefix) = &self.slug_prefix
            && !slug.to_ascii_lowercase().starts_with(prefix)
        {
            return false;
        }

        if let Some(expected_folder) = &self.folder {
            match folder.map(|f| f.to_ascii_lowercase()) {
                Some(actual) if &actual == expected_folder => {}
                _ => return false,
            }
        }

        if let Some(glob) = &self.path_glob
            && !glob.is_match(path)
        {
            return false;
        }

        true
    }
}