{"versions":{"0.0.3":{"name":"@zhiweixu/excel-mcp-server","version":"0.0.3","type":"module","main":"index.js","repository":{"type":"git","url":"git+https://github.com/zhiwei5576/excel-mcp-server.git"},"scripts":{"start":"node dist/index.js","dev":"nodemon src/index.ts","build":"tsc","watch":"tsc -w"},"keywords":[],"author":{"name":"zhiweixu"},"license":"MIT","description":"Excel file processing server based on Model Context Protocol (MCP)","devDependencies":{"@types/node":"^22.13.10","nodemon":"^3.1.9","ts-node":"^10.9.2","typescript":"^5.8.2"},"dependencies":{"@modelcontextprotocol/sdk":"^1.7.0","xlsx":"^0.18.5"},"publishConfig":{"access":"public"},"volta":{"node":"18.20.6","npm":"10.8.2"},"_id":"@zhiweixu/excel-mcp-server@0.0.3","gitHead":"54b85da9f0ddd15065fba3f11cae1aafea79a64c","bugs":{"url":"https://github.com/zhiwei5576/excel-mcp-server/issues"},"homepage":"https://github.com/zhiwei5576/excel-mcp-server#readme","_nodeVersion":"18.20.7","_npmVersion":"10.8.2","dist":{"integrity":"sha512-rC5Fj8tzE3jcQPuaXfy6tHNDI3jrWE2kKI8vHHUw2ITeivfYOTgNRdfxCuA+sZ7R4ZdDLeExQjIYyCccLHjTkA==","shasum":"db98fc0bb45a69a527e0e4df425a73f377253684","tarball":"http://123.232.10.234:8212/nexus/content/groups/npm-public/@zhiweixu/excel-mcp-server/-/excel-mcp-server-0.0.3.tgz","fileCount":18,"unpackedSize":51815,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEQCIEaCUw97kGdJfS5eL41JVsgieISQjejG0EjYdtGlhF5TAiAk9j3sZf4SIpG4oD1P8vvejoE8ITv+5xh9Yw1IYJrASQ=="}],"size":11046},"_npmUser":{"name":"anonymous","email":"zhiwei5576@163.com"},"directories":{},"maintainers":[{"name":"anonymous","email":"zhiwei5576@163.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/excel-mcp-server_0.0.3_1742386605333_0.2429117079114591"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2025-03-19T12:16:45.564Z","publish_time":1742386605564,"_source_registry_name":"default","contributors":[]},"0.0.4":{"name":"@zhiweixu/excel-mcp-server","version":"0.0.4","type":"module","main":"index.js","bin":{"excel-mcp-server":"dist/index.js"},"repository":{"type":"git","url":"git+https://github.com/zhiwei5576/excel-mcp-server.git"},"scripts":{"start":"node dist/index.js","dev":"nodemon src/index.ts","build":"tsc","watch":"tsc -w"},"keywords":[],"author":{"name":"zhiweixu"},"license":"MIT","description":"Excel file processing server based on Model Context Protocol (MCP)","devDependencies":{"@types/node":"^22.13.10","nodemon":"^3.1.9","ts-node":"^10.9.2","typescript":"^5.8.2"},"dependencies":{"@modelcontextprotocol/sdk":"^1.7.0","xlsx":"^0.18.5"},"publishConfig":{"access":"public"},"volta":{"node":"18.20.6","npm":"10.8.2"},"_id":"@zhiweixu/excel-mcp-server@0.0.4","gitHead":"3696b7a88196e15c9346619684d4d874a972c57d","bugs":{"url":"https://github.com/zhiwei5576/excel-mcp-server/issues"},"homepage":"https://github.com/zhiwei5576/excel-mcp-server#readme","_nodeVersion":"18.20.7","_npmVersion":"10.8.2","dist":{"integrity":"sha512-phg1PLSF2NwYRiH57z0Ru74rBykjnNwY2AkylhjkMb0ckTtXhZ7gCooeS5ubamsHrdKyLoqS4/FCQy3gwt8eQw==","shasum":"ce0bc84345a0bc2f0bb09982e6a9be8dec55fd26","tarball":"http://123.232.10.234:8212/nexus/content/groups/npm-public/@zhiweixu/excel-mcp-server/-/excel-mcp-server-0.0.4.tgz","fileCount":17,"unpackedSize":53607,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEQCIHxug6SNZ+yTYq/xD4UtQ+/AuhY7SjwdM0dre3N6NKleAiBk89c275AIdK6GzzQGa6izW3BYuHvfxaZaV1QoYJEx4Q=="}],"size":11264},"_npmUser":{"name":"anonymous","email":"zhiwei5576@163.com"},"directories":{},"maintainers":[{"name":"anonymous","email":"zhiwei5576@163.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/excel-mcp-server_0.0.4_1742440424004_0.16183161725573258"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2025-03-20T03:13:44.179Z","publish_time":1742440424179,"_source_registry_name":"default","contributors":[]},"0.0.5":{"name":"@zhiweixu/excel-mcp-server","version":"0.0.5","type":"module","main":"index.js","bin":{"excel-mcp-server":"dist/index.js"},"repository":{"type":"git","url":"git+https://github.com/zhiwei5576/excel-mcp-server.git"},"scripts":{"start":"node dist/index.js","dev":"nodemon src/index.ts","build":"tsc","watch":"tsc -w"},"keywords":[],"author":{"name":"zhiweixu"},"license":"MIT","description":"Excel file processing server based on Model Context Protocol (MCP)","devDependencies":{"@types/node":"^22.13.10","nodemon":"^3.1.9","ts-node":"^10.9.2","typescript":"^5.8.2"},"dependencies":{"@modelcontextprotocol/sdk":"^1.7.0","xlsx":"^0.18.5"},"publishConfig":{"access":"public"},"volta":{"node":"18.20.6","npm":"10.8.2"},"_id":"@zhiweixu/excel-mcp-server@0.0.5","gitHead":"cf0e7c98b95e77f77628c33c6ca4af87a79b3ac8","bugs":{"url":"https://github.com/zhiwei5576/excel-mcp-server/issues"},"homepage":"https://github.com/zhiwei5576/excel-mcp-server#readme","_nodeVersion":"18.20.8","_npmVersion":"10.8.2","dist":{"integrity":"sha512-k+i8IifakoisBVa/MYCH3cUaxqkSoVlSHfuc+RhxIf4Uvg1s1Ab+IB8KZ2wOKIEh6bEO1hwNy8cKrt6vU1kj1A==","shasum":"a97b3706ada22a69ad60f43581771f3a584a690b","tarball":"http://123.232.10.234:8212/nexus/content/groups/npm-public/@zhiweixu/excel-mcp-server/-/excel-mcp-server-0.0.5.tgz","fileCount":17,"unpackedSize":56878,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEQCIER/bkFnMRFXCb8kCzLs3O4ns2P6rvkhV5dINwZmFYgvAiBDIEaThnFdryugCRwz5iEIWDpz3TYlF8p8wEYPjOpAhQ=="}],"size":11891},"_npmUser":{"name":"anonymous","email":"zhiwei5576@163.com"},"directories":{},"maintainers":[{"name":"anonymous","email":"zhiwei5576@163.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/excel-mcp-server_0.0.5_1744265966060_0.9845542801142793"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2025-04-10T06:19:26.239Z","publish_time":1744265966239,"_source_registry_name":"default","contributors":[]}},"dist-tags":{"latest":"0.0.5"},"name":"@zhiweixu/excel-mcp-server","time":{"created":"2025-03-19T12:20:56.672Z","modified":"2025-04-10T18:14:25.870Z","0.0.3":"2025-03-19T12:16:45.564Z","0.0.4":"2025-03-20T03:13:44.179Z","0.0.5":"2025-04-10T06:19:26.239Z"},"readme":"# Excel MCP Server\n[![npm](https://img.shields.io/npm/v/@zhiweixu/excel-mcp-server)](https://www.npmjs.com/package/@zhiweixu/excel-mcp-server)\n[![smithery badge](https://smithery.ai/badge/@zhiwei5576/excel-mcp-server)](https://smithery.ai/server/@zhiwei5576/excel-mcp-server)\n[简体中文](./README_CN.md) | English\n\nExcel file processing server based on Model Context Protocol (MCP), providing functionalities for reading, writing, and analyzing Excel files.\n\n## Features\n\n- 📖 Read Excel Files\n\n  - Get worksheet list\n  - Read specific worksheet data\n  - Read all worksheets data\n\n- ✍️ Write Excel Files\n\n  - Create new Excel files\n  - Write to specific worksheet\n  - Support multiple worksheets\n\n- 🔍 Analyze Excel Structure\n\n  - Analyze worksheet structure\n  - Export structure to new file\n\n- 💾 Cache Management\n\n  - Automatic file content caching\n  - Scheduled cache cleanup\n  - Manual cache clearing\n\n- 📝 Log Management\n  - Automatic operation logging\n  - Periodic log cleanup\n\n## Installation\n\n### Installing via Smithery\n\nTo install excel-mcp-server for Claude Desktop automatically via [Smithery](https://smithery.ai/server/@zhiwei5576/excel-mcp-server):\n\n```bash\nnpx -y @smithery/cli install @zhiwei5576/excel-mcp-server --client claude\n```\n\n### Installing Manually\nInstalling via NPM\nexcel-mcp-server can be automatically installed by adding the following configuration to the MCP servers configuration.\n\nWindows Platform:\n\n```bash\n{\n  \"mcpServers\": {\n    \"excel\": {\n        \"command\": \"cmd\",\n        \"args\": [\"/c\", \"npx\", \"--yes\", \"@zhiweixu/excel-mcp-server\"],\n        \"env\": {\n            \"LOG_PATH\": \"[set an accessible absolute path]\",\n            \"CACHE_MAX_AGE\": \"1\",\n            \"CACHE_CLEANUP_INTERVAL\": \"4\",\n            \"LOG_RETENTION_DAYS\": \"7\",\n            \"LOG_CLEANUP_INTERVAL\": \"24\"\n        }\n    }\n}\n```\n\nOther Platforms:\n\n```bash\n{\n  \"mcpServers\": {\n    \"excel\": {\n        \"command\": \"npx\",\n        \"args\": [\"--yes\", \"@zhiweixu/excel-mcp-server\"],\n        \"env\": {\n            \"LOG_PATH\": \"[set an accessible absolute path]\",\n            \"CACHE_MAX_AGE\": \"1\",\n            \"CACHE_CLEANUP_INTERVAL\": \"4\",\n            \"LOG_RETENTION_DAYS\": \"7\",\n            \"LOG_CLEANUP_INTERVAL\": \"24\"\n        }\n    }\n}\n```\nNote: LOG_PATH is optional. If not set, logs will be stored in the 'logs' folder under the application root directory.other arguments are optional.\n\n## API Tools\n\n### Structure Tools\n\n1. analyzeExcelStructure\n   - Function: Get Excel file structure including sheet list and column headers in JSON format\n   - Parameters:\n     - fileAbsolutePath: Absolute path of the Excel file\n     - headerRows: Number of header rows (default: 1)\n\n2. exportExcelStructure\n   - Function: Export Excel file structure (sheets and headers) to a new Excel template file\n   - Parameters:\n     - sourceFilePath: Source Excel file path\n     - targetFilePath: Target Excel file path\n     - headerRows: Number of header rows (default: 1)\n\n### Read Tools\n\n1. readSheetNames\n   - Function: Get all sheet names from the Excel file\n   - Parameters:\n     - fileAbsolutePath: Absolute path of the Excel file\n\n2. readDataBySheetName\n   - Function: Get data from a specific sheet in the Excel file\n   - Parameters:\n     - fileAbsolutePath: Absolute path of the Excel file\n     - sheetName: Name of the sheet to read\n     - headerRow: Header row number (default: 1)\n     - dataStartRow: Data start row number (default: 2)\n\n3. readSheetData\n   - Function: Get data from all sheets in the Excel file\n   - Parameters:\n     - fileAbsolutePath: Absolute path of the Excel file\n     - headerRow: Header row number (default: 1)\n     - dataStartRow: Data start row number (default: 2)\n\n### Write Tools\n\n1. writeDataBySheetName\n   - Function: Write data to a specific sheet in the Excel file (overwrites if sheet exists)\n   - Parameters:\n     - fileAbsolutePath: Absolute path of the Excel file\n     - sheetName: Name of the sheet to write\n     - data: Array of data to write\n\n2. writeSheetData\n   - Function: Create a new Excel file with provided data\n   - Parameters:\n     - fileAbsolutePath: Absolute path for the new Excel file\n     - data: Object containing multiple sheet data\n\n### Cache Tools\n\n1. clearFileCache\n   - Function: Clear cached data for the specified Excel file\n   - Parameters:\n     - fileAbsolutePath: Absolute path of the Excel file to clear from cache\n\n## Configuration\n\n### Environment Variables\n\n- `LOG_PATH`: Log files storage path\n  - Optional\n  - Default: 'logs' folder under application root directory\n\n- `CACHE_MAX_AGE`: Cache expiration time (hours)\n  - Optional\n  - Default: 1\n\n- `CACHE_CLEANUP_INTERVAL`: Cache cleanup interval (hours)\n  - Optional\n  - Default: 4\n\n- `LOG_RETENTION_DAYS`: Log retention days\n  - Optional\n  - Default: 7\n\n- `LOG_CLEANUP_INTERVAL`: Log cleanup interval (hours)\n  - Optional\n  - Default: 24\n\n### Default Configuration\n\n- Cache Configuration\n  - Cache expiration time: 1 hour\n  - Cache cleanup interval: 4 hours\n\n- Log Configuration\n  - Log retention days: 7 days\n  - Cleanup interval: 24 hours\n\n## Dependencies\n\n- @modelcontextprotocol/sdk: ^1.7.0\n- xlsx: ^0.18.5\n- typescript: ^5.8.2\n\n## Development Dependencies\n\n- @types/node: ^22.13.10\n- nodemon: ^3.1.9\n- ts-node: ^10.9.2\n\n## License\n\nThis project is licensed under the MIT License. This means you are free to:\n\n- Use the software for commercial or non-commercial purposes\n- Modify the source code\n- Distribute original or modified code\n  Requirements:\n\n- Retain the original copyright notice\n- No liability can be claimed against the authors for software use\n  For detailed license information,please see the [LICENSE](./LICENSE) file.","users":{}}