Skip to main content
Glama

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault

No arguments

Capabilities

Features and capabilities supported by this server

CapabilityDetails
tools
{
  "listChanged": false
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
create_workbookA

Create a new empty workbook.

Args: name: Workbook name locale: Locale code (e.g. en, de, es, fr) timezone: Timezone (e.g. UTC, America/New_York) language: Language code for formulas (e.g. en, es, de)

load_workbookA

Load a workbook from an xlsx file.

Args: file_path: Absolute path to the .xlsx file locale: Locale code (e.g. en, de, es) timezone: Timezone (e.g. UTC) language: Language code for formulas (e.g. en)

save_workbookA

Save the current workbook to an xlsx file.

Args: file_path: Path to save to. If omitted, saves to the path it was loaded from.

get_workbook_infoA

Get information about the current workbook: sheets, dimensions, and metadata.

get_cellA

Get a single cell's content, formatted value, and type.

Args: sheet: Sheet index (0-based) row: Row number (1-based) column: Column number (1-based)

get_cellsA

Get cells in a rectangular range.

Args: sheet: Sheet index (0-based) row_start: First row (1-based) col_start: First column (1-based) row_end: Last row (1-based, inclusive) col_end: Last column (1-based, inclusive)

set_cellA

Set a single cell's value. Use '=' prefix for formulas.

Args: sheet: Sheet index (0-based) row: Row number (1-based) column: Column number (1-based) value: Cell value (text, number, or formula starting with '=')

set_cellsA

Set multiple cells in batch. Each entry needs sheet, row, column, value.

Args: cells: List of {sheet: int, row: int, column: int, value: str}

add_sheetA

Add a new sheet to the workbook.

Args: name: Optional sheet name. If omitted, auto-named (Sheet2, Sheet3, etc.)

delete_sheetB

Delete a sheet by index.

Args: sheet: Sheet index (0-based)

rename_sheetA

Rename a sheet.

Args: sheet: Sheet index (0-based) name: New sheet name

set_sheet_colorA

Set the tab color of a sheet.

Args: sheet: Sheet index (0-based) color: Hex color string (e.g. '#FF0000')

insert_rowsB

Insert rows at the given position.

Args: sheet: Sheet index (0-based) row: Row number where new rows are inserted (1-based) count: Number of rows to insert

delete_rowsB

Delete rows starting at the given position.

Args: sheet: Sheet index (0-based) row: First row to delete (1-based) count: Number of rows to delete

insert_columnsB

Insert columns at the given position.

Args: sheet: Sheet index (0-based) column: Column number where new columns are inserted (1-based) count: Number of columns to insert

delete_columnsB

Delete columns starting at the given position.

Args: sheet: Sheet index (0-based) column: First column to delete (1-based) count: Number of columns to delete

set_column_widthB

Set the width of a column.

Args: sheet: Sheet index (0-based) column: Column number (1-based) width: Column width in points

set_row_heightA

Set the height of a row.

Args: sheet: Sheet index (0-based) row: Row number (1-based) height: Row height in points

set_frozen_rowsA

Freeze the top N rows.

Args: sheet: Sheet index (0-based) count: Number of rows to freeze (0 to unfreeze)

set_frozen_columnsA

Freeze the left N columns.

Args: sheet: Sheet index (0-based) count: Number of columns to freeze (0 to unfreeze)

get_cell_styleA

Get the style (font, fill, border, alignment, number format) of a cell.

Args: sheet: Sheet index (0-based) row: Row number (1-based) column: Column number (1-based)

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/yolonir/ironcalc-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server