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

use crate::security::basic_string_literal;
use anyhow::Result;

/// Build a LibreOffice `macro:///...` URI for `Standard.Module1.ExportScreenshot`.
///
/// Arguments are escaped for Basic string literal context to prevent injection.
pub fn export_screenshot_uri(
    workbook_path: &str,
    output_path: &str,
    sheet_name: &str,
    range: &str,
) -> Result<String> {
    Ok(format!(
        "macro:///Standard.Module1.ExportScreenshot({},{},{},{})",
        basic_string_literal("workbook_path", workbook_path)?,
        basic_string_literal("output_path", output_path)?,
        basic_string_literal("sheet_name", sheet_name)?,
        basic_string_literal("range", range)?,
    ))
}

/// Build a LibreOffice `macro:///...` URI for `Standard.Module1.RecalculateAndSave`.
///
/// Arguments are escaped for Basic string literal context to prevent injection.
pub fn recalc_and_save_uri(workbook_path: &str) -> Result<String> {
    Ok(format!(
        "macro:///Standard.Module1.RecalculateAndSave({})",
        basic_string_literal("workbook_path", workbook_path)?,
    ))
}