MCP.so
ログイン

mysheet MCP Server

@lgwanai

基本情報

カテゴリ

その他

ライセンス

MIT

トランスポート

stdio

作者

lgwanai

mysheet MCP Server について

Mysheet-mcp is a MCP Server for converting Excel files into JSON format, particularly useful for data processing when called within large models or Agents.

mysheet MCP Server の設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

mysheet MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is mysheet MCP Server?

mysheet MCP Server is a Model Context Protocol server that converts Excel files into JSON format, with optional automatic uploading of embedded files to Tencent Cloud COS (Object Storage). It is designed for data processing within large language models or AI agents.

How to use mysheet MCP Server?

Install Java 21+ and Maven 3.6+, configure Tencent Cloud COS credentials and storage paths in application.yml, then start the server via ./mvnw spring-boot:run. The server exposes MCP tools (excel2Json, openFile, foreach, reset) that an AI agent can invoke to parse Excel files, manage sessions, and retrieve JSON data.

Key features of mysheet MCP Server

  • Converts Excel files to JSON with detailed cell type information (text, number, money, date, file, boolean)
  • Supports "row-object" parsing mode where each row becomes a JSON object
  • Automatically uploads embedded files to Tencent Cloud COS and replaces local paths with COS URLs
  • Uses Java 21 virtual threads for concurrent file uploads, boosting performance on large files
  • Provides session management (openFile, foreach, reset) for reading large Excel files in batches
  • Implements an MD5‑based cache to avoid re‑parsing identical files; cached data expires after 24 hours

Use cases of mysheet MCP Server

  • Extracting structured data from Excel spreadsheets for LLM ingestion
  • Processing Excel files that contain embedded images, documents, or other attachments stored on COS
  • Handling large Excel files by reading rows in chunks through session‑based cursors
  • Automating batch Excel‑to‑JSON conversion in AI agent workflows

よくある質問

1

What Excel file formats are supported?

The server supports both `.xls` and `.xlsx` formats.

2

What are the runtime requirements?

Java 21 or higher (mandatory for virtual threads), Maven 3.6+, and a Tencent Cloud COS account for file storage.

3

How do I configure Tencent Cloud COS?

Edit `src/main/resources/application.yml` to set your COS secret‑id, secret‑key, region, and bucket‑name.

4

How does the cache work?

The server computes an MD5 hash of the uploaded Excel file and checks for a cached JSON file. If found, it returns the cached result. Cached session data is kept in memory for 24 hours and cleaned hourly.

5

What is the session timeout?

Sessions remain active in memory for 24 hours. The cleanup process runs every hour to remove expired sessions.

コメント

「その他」の他のコンテンツ