What is Fastexecl Mcp Server

fastexecl-mcp-server is a Java server that implements the Model Context Protocol (MCP) for performing Excel operations, providing standardized relationships between headers and columns.

Use cases

Use cases include data extraction from Excel files for analysis, generating reports based on Excel data, and integrating Excel data into other applications.

How to use

To use fastexecl-mcp-server, configure the MCP_WORKSPACES environment variable to specify allowed directories. Use the provided API methods to read Excel files, validate paths, and retrieve data.

Key features

Key features include reading Excel files (XLSX, XLS, CSV), validating input paths, supporting multiple sheets and custom headers, and retrieving the total number of data rows excluding headers.

Where to use

fastexecl-mcp-server can be used in data processing applications, reporting tools, and any environment where Excel data manipulation is required.

FastExcel MCP Server

Java server implementing Model Context Protocol (MCP) for Excel operations with standardized header-to-column relationships.

Features

• Read Excel file (XLSX, XLS, CSV) headers and data rows.
• Validate input paths against configured workspaces.
• Support for multiple sheets and custom header rows.
• Retrieve total number of data rows (excluding headers).
• Built-in performance caching for faster repeated access.

Note: The server will only allow operations within directories specified via env: MCP_WORKSPACES.

API

Tools

• get_total_rows_number (with cache support)

  • Get the total number of data rows (excluding the header row) in an Excel file.
  • Inputs:
    • excelPath (string): Absolute or relative path to the Excel file.
    • headRowNumber (integer): Row number (1-based index) where the header is located.
    • sheetName (string, optional): Name of the sheet to read. Defaults to the first sheet if empty.
  • Returns the total count of data rows as an integer.

• get_sheet_names (with cache support)

  • Retrieve all sheet names and their indices from an Excel file.
  • Inputs:
    • excelPath (string): Absolute or relative path to the Excel file.
  • Returns a list of json objects containing sheet number and sheet name.

• read_head_spec (with cache support)

  • Parse and return the header information from an Excel file.
  • Inputs:
    • excelPath (string): Absolute or relative path to the Excel file.
    • headRowNumber (integer): Row number (1-based index) where the header is located.
    • sheetName (string, optional): Name of the sheet to read. Defaults to the first sheet if empty.
  • Returns a sorted list of json objects containing column index and header titles.

• read_rows_spec (with cache support)

  • Parse and return the data rows from an Excel file with header association.
  • Inputs:
    • excelPath (string): Absolute or relative path to the Excel file.
    • headRowNumber (integer): Row number (1-based index) where the header is located.
    • readRowNumbers (integer, optional): Number of data rows to read (excludes header). If null, reads all rows.
    • sheetName (string, optional): Name of the sheet to read. Defaults to the first sheet if empty.
  • Returns a list of json containing row data linked to their headers.

• cache_clear

  • Clear all cached Excel file data from memory.
  • Returns true when cache is cleared successfully.

• test_cache_available

  • Test if the specified Excel file is available in cache.
  • Inputs:
    • excelPath (string): Absolute or relative path to the Excel file.
  • Returns a json object indicating cache status and file MD5 hash:
    • cached: boolean indicating if file is cached
    • result: string containing file MD5 hash information

Usage with Claude Desktop

Add this to your claude_desktop_config.json:

Java

{
  "mcpServers": {
    "fastexcel-mcp-server": {
      "command": "java",
      "args": [
        "-jar",
        "<YOUR_PATH>/fastexcel-mcp-server-0.0.1-SNAPSHOT.jar"
      ],
      "env": {
        "MCP_WORKSPACES": "<YOUR_MULTIPLE_WORKSPACES_SEPARATED_BY_COMMAS>",
        "CACHE_INITIAL_CAPACITY": "[OPTIONAL] <MINIMUM_TOTAL_SIZE_FOR_THE_INTERNAL_DATA_STRUCTURES> <DEFAULT: 100>",
        "CACHE_MAXIMUM_SIZE": "[OPTIONAL] <MAXIMUM_NUMBER_OF_ENTRIES_THE_CACHE_MAY_CONTAIN> <DEFAULT: 1000>",
        "CACHE_EXPIRE_AFTER_WRITE": "[OPTIONAL] <LENGTH_OF_TIME_AFTER_AN_ENTRY_IS_CREATED_THAT_IT_SHOULD_BE_AUTOMATICALLY_REMOVED> <DEFAULT: 35s>"
      }
    }
  }
}

Build

Required

• JDK 17+ GraalVM
• Maven 3.9.6+

Java build:

mvn clean package -DskipTests=true

License

This MCP server is licensed under the Apache License 2.0. For more details, please see the LICENSE file in the project repository.

If you need further customization or integration details, let me know!