Skip to main content
Glama

Dynamic Excel MCP Server

by nam090320251

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
API_KEYNoOptional API key for authentication (used when TRANSPORT_MODE is 'http')
HTTP_HOSTNoHost for HTTP server (required when TRANSPORT_MODE is 'http')0.0.0.0
HTTP_PORTNoPort for HTTP server (required when TRANSPORT_MODE is 'http')3000
LOG_LEVELNoLogging levelinfo
S3_BUCKETNoS3 bucket name (required when STORAGE_TYPE is 's3')
AWS_REGIONNoAWS region (required when STORAGE_TYPE is 's3')
STORAGE_TYPENoStorage type: 'local' for local file system, 's3' for AWS S3
TRANSPORT_MODENoTransport mode: 'stdio' for local MCP client mode, 'http' for remote server modestdio
ALLOWED_ORIGINSNoCORS allowed origins (required when TRANSPORT_MODE is 'http')*
DEV_STORAGE_PATHNoPath for local file storage./temp-files
AWS_ACCESS_KEY_IDNoAWS access key ID (required when STORAGE_TYPE is 's3')
PRESIGNED_URL_EXPIRYNoExpiry time for presigned URLs in seconds (used when STORAGE_TYPE is 's3')3600
AWS_SECRET_ACCESS_KEYNoAWS secret access key (required when STORAGE_TYPE is 's3')

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
generate_excel

Generate an Excel file from a structured JSON schema.

Use this tool when the user wants to:

  • Create an Excel file

  • Export data to Excel

  • Generate a report/spreadsheet

  • Download data as .xlsx file

The tool accepts a JSON schema describing the structure, data, and formatting of the Excel file.

Supported features:

  • Multiple sheets

  • Custom column widths and formats

  • Cell styling (fonts, colors, borders, alignment)

  • Data validation

  • Conditional formatting

  • Formulas and totals

  • Charts and images

  • Page setup and printing options

  • Freeze panes, auto-filter

  • Merged cells

  • Grouped rows/columns

  • Sheet protection

Layout types:

  • table: Simple data table (default)

  • report: Formatted report with headers and styling

  • form: Form-style layout

  • dashboard: Dashboard with charts

  • calendar: Calendar view

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/nam090320251/dynamic-excel-mcp-server'

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