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

use umya_spreadsheet::Cell;

#[derive(Debug, Clone)]
pub struct StyleTagging {
    pub tags: Vec<String>,
    pub example_cell: String,
}

pub fn tag_cell(cell: &Cell) -> Option<(String, StyleTagging)> {
    let style = cell.get_style();
    let mut tags = Vec::new();

    if let Some(font) = style.get_font() {
        if *font.get_bold() {
            tags.push("header".to_string());
        }
        if *font.get_italic() {
            tags.push("emphasis".to_string());
        }
    }

    if let Some(number_format) = style.get_number_format() {
        let format_code = number_format.get_format_code().to_ascii_lowercase();
        if format_code.contains("$") {
            tags.push("currency".to_string());
        } else if format_code.contains("%") {
            tags.push("percentage".to_string());
        } else if format_code.contains("yy") {
            tags.push("date".to_string());
        }
    }

    if tags.is_empty() {
        return None;
    }

    let coordinate = cell.get_coordinate();
    let address = coordinate.get_coordinate();
    let key = tags.join("|");

    Some((
        key,
        StyleTagging {
            tags,
            example_cell: address,
        },
    ))
}