{"_id":"@anh9thgg/mcp-excel","_rev":"3-40429cec2b44196a7f0aae2ced0154b7","name":"@anh9thgg/mcp-excel","dist-tags":{"latest":"1.1.0"},"versions":{"1.0.0":{"name":"@anh9thgg/mcp-excel","version":"1.0.0","keywords":["mcp","excel","model-context-protocol"],"author":{"name":"anh9th"},"license":"ISC","_id":"@anh9thgg/mcp-excel@1.0.0","maintainers":[{"name":"anh9th","email":"anh.tran@gravityglobal.com"}],"homepage":"https://github.com/anh9th/mcp-excel#readme","bugs":{"url":"https://github.com/anh9th/mcp-excel/issues"},"bin":{"mcp-excel":"dist/index.js"},"dist":{"shasum":"c50e9013e269fd407fb16ca55bcbb12d46606fe9","tarball":"https://registry.npmjs.org/@anh9thgg/mcp-excel/-/mcp-excel-1.0.0.tgz","fileCount":11,"integrity":"sha512-6t6UpSq0HOVizLz3VOMfqq1TOzbx83Y0NteCRi3Ib+RiGeOdy09mBhZvXXKrM0DFl0RtpPMMjp9g5KHruM10EQ==","signatures":[{"sig":"MEUCICzkW2Ml7gI41XbFvbGwXmV+26YxiTfJkVftUnKuyDQYAiEA7LmIZyIxjLEb+PWHyI6iS3aXqdElBZq0y84Eq5B/XwE=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":42127},"main":"dist/index.js","type":"module","types":"./dist/index.d.ts","engines":{"node":">=14.0.0"},"gitHead":"8b1855564e1bf7e8697972f0e4c7d0d042e88e87","scripts":{"dev":"tsc && node dist/index.js","test":"tsc && node dist/test.js","build":"tsc","start":"node dist/index.js","prepare":"npm run build"},"_npmUser":{"name":"anh9th","email":"anh.tran@gravityglobal.com"},"repository":{"url":"git+https://github.com/anh9th/mcp-excel.git","type":"git"},"_npmVersion":"9.6.7","description":"MCP server for Excel integration","directories":{},"_nodeVersion":"18.17.0","dependencies":{"zod":"^3.22.4","exceljs":"^4.3.0","@modelcontextprotocol/sdk":"^1.9.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.3.3","@types/node":"^20.10.5"},"_npmOperationalInternal":{"tmp":"tmp/mcp-excel_1.0.0_1745344996992_0.7251981339525682","host":"s3://npm-registry-packages-npm-production"}},"1.0.1":{"name":"@anh9thgg/mcp-excel","version":"1.0.1","keywords":["mcp","excel","model-context-protocol"],"author":{"name":"anh9th"},"license":"ISC","_id":"@anh9thgg/mcp-excel@1.0.1","maintainers":[{"name":"anh9th","email":"anh.tran@gravityglobal.com"}],"homepage":"https://github.com/anh9th/mcp-excel#readme","bugs":{"url":"https://github.com/anh9th/mcp-excel/issues"},"bin":{"mcp-excel":"dist/index.js"},"dist":{"shasum":"11b4d8005215a233cae6603535d9f3aa1d7dc8c0","tarball":"https://registry.npmjs.org/@anh9thgg/mcp-excel/-/mcp-excel-1.0.1.tgz","fileCount":11,"integrity":"sha512-3YjYvanAFev/zrxnyrpx8Gq1JCHzvcxF9sw/5SzLiLGtih0vV8vg0WfCN6/S7vb2jkaqK8Pys7upOqD1jkmtYg==","signatures":[{"sig":"MEUCIEdCdV6DxVe73nAyeMSr42KNmkxIl/MdHvQpwBze8jz1AiEAgyJL5ODcqQT6og5zy0jSKuHCiwzncskYil6mopiZbHo=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":57713},"main":"dist/index.js","type":"module","types":"./dist/index.d.ts","engines":{"node":">=14.0.0"},"gitHead":"a3da44799dd491c66c7e95497425b4589ad63266","scripts":{"dev":"tsc && node dist/index.js","test":"tsc && node dist/test.js","build":"tsc","start":"node dist/index.js","prepare":"npm run build"},"_npmUser":{"name":"anh9th","email":"anh.tran@gravityglobal.com"},"repository":{"url":"git+https://github.com/anh9th/mcp-excel.git","type":"git"},"_npmVersion":"9.6.7","description":"MCP server for Excel integration","directories":{},"_nodeVersion":"18.17.0","dependencies":{"zod":"^3.22.4","exceljs":"^4.3.0","@modelcontextprotocol/sdk":"^1.9.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.3.3","@types/node":"^20.10.5"},"_npmOperationalInternal":{"tmp":"tmp/mcp-excel_1.0.1_1745347127736_0.4135164001567133","host":"s3://npm-registry-packages-npm-production"}},"1.1.0":{"name":"@anh9thgg/mcp-excel","version":"1.1.0","description":"MCP server for Excel integration","main":"dist/index.js","type":"module","bin":{"mcp-excel":"dist/index.js"},"scripts":{"build":"tsc","start":"node dist/index.js","dev":"tsc && node dist/index.js","test":"tsc && node dist/test.js","prepare":"npm run build"},"keywords":["mcp","excel","model-context-protocol"],"author":{"name":"anh9th"},"license":"ISC","dependencies":{"@modelcontextprotocol/sdk":"^1.9.0","exceljs":"^4.3.0","zod":"^3.22.4"},"devDependencies":{"@types/node":"^20.10.5","typescript":"^5.3.3"},"engines":{"node":">=14.0.0"},"publishConfig":{"access":"public"},"repository":{"type":"git","url":"git+https://github.com/anh9th/mcp-excel.git"},"types":"./dist/index.d.ts","bugs":{"url":"https://github.com/anh9th/mcp-excel/issues"},"homepage":"https://github.com/anh9th/mcp-excel#readme","gitHead":"ab9acf6a97499616d9075fa00f220139f4d4c267","_id":"@anh9thgg/mcp-excel@1.1.0","_nodeVersion":"18.17.0","_npmVersion":"9.6.7","dist":{"integrity":"sha512-fcXwI67SaELSoex6iNBuxsIUIjoerXCrguAbUtBg2egwJ0NYVgGk89rmOHpMCsztLABAImWFz3AlEyWHZQwEnQ==","shasum":"c089e3bf0e7573cad6c49b1fe04808136e4be1c4","tarball":"https://registry.npmjs.org/@anh9thgg/mcp-excel/-/mcp-excel-1.1.0.tgz","fileCount":11,"unpackedSize":60120,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCICaQU/+z6N22O8ecMcVxowyk3eps/oiB83T5m7olub3tAiEA+nmi0hRJ3Dj6Kl4VegQLryrAPOggcKvhaQ159XP8Ug0="}]},"_npmUser":{"name":"anh9th","email":"anh.tran@gravityglobal.com"},"directories":{},"maintainers":[{"name":"anh9th","email":"anh.tran@gravityglobal.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mcp-excel_1.1.0_1745351048301_0.8073474600864885"},"_hasShrinkwrap":false}},"time":{"created":"2025-04-22T18:03:16.906Z","modified":"2025-04-22T19:44:08.682Z","1.0.0":"2025-04-22T18:03:17.167Z","1.0.1":"2025-04-22T18:38:47.936Z","1.1.0":"2025-04-22T19:44:08.486Z"},"bugs":{"url":"https://github.com/anh9th/mcp-excel/issues"},"author":{"name":"anh9th"},"license":"ISC","homepage":"https://github.com/anh9th/mcp-excel#readme","keywords":["mcp","excel","model-context-protocol"],"repository":{"type":"git","url":"git+https://github.com/anh9th/mcp-excel.git"},"description":"MCP server for Excel integration","maintainers":[{"name":"anh9th","email":"anh.tran@gravityglobal.com"}],"readme":"# MCP Excel\n\nA Model Context Protocol (MCP) server for Excel operations, allowing you to read and write Microsoft Excel files programmatically.\n\n## Features\n\n- Create new Excel workbooks\n- Read/write cell values\n- Read/write cell formulas\n- Read/write ranges of cells\n- Read/write formula ranges\n- List, create, and delete worksheets in a workbook\n\n## Supported File Formats\n\n- `.xlsx` (Excel Workbook)\n- `.xlsm` (Excel Macro-enabled Workbook)\n- `.xltx` (Excel Template)\n- `.xltm` (Excel Macro-enabled Template)\n\n## Prerequisites\n\n- Node.js >= 14.0.0\n- npm or yarn\n\n## Installation\n\n### Option 1: Using npx (Recommended)\n\nRun directly using npx:\n```bash\nnpx @anh9thgg/mcp-excel@latest\n```\n\nOr install globally:\n```bash\nnpm install -g @anh9thgg/mcp-excel\nmcp-excel\n```\n\n### Option 2: Cursor Integration (Windows)\n\nTo integrate with Cursor IDE on Windows, add the following to your Cursor configuration:\n\n1. Open Cursor settings\n2. Navigate to the MCP configuration section\n3. Add the following configuration:\n\n```json\n{\n  \"mcps\": {\n    \"mcp-excel\": {\n      \"command\": \"C:\\\\Windows\\\\System32\\\\cmd.exe\",\n      \"args\": [\n        \"/c\",\n        \"npx\",\n        \"-y\",\n        \"@anh9thgg/mcp-excel@latest\"\n      ]\n    }\n  }\n}\n```\n\nThis configuration:\n- Uses Windows Command Prompt (`cmd.exe`) to execute the command\n- Uses `npx` to run the latest version of the package\n- The `-y` flag automatically answers \"yes\" to any prompts\n- `@latest` ensures you always get the most recent version\n\n### Option 3: Clone and Run Locally\n\n1. Clone the repository:\n```bash\ngit clone https://github.com/anh9th/mcp-excel.git\ncd mcp-excel\n```\n\n2. Install dependencies:\n```bash\nnpm install\n```\n\n3. Build the project:\n```bash\nnpm run build\n```\n\n4. Run the server:\n```bash\nnpm start\n```\n\n## Development\n\nTo run in development mode with automatic compilation:\n```bash\nnpm run dev\n```\n\n## Publishing\n\nTo publish a new version to npm:\n\n1. Create an npm account (if you don't have one):\n   - Visit https://www.npmjs.com/signup\n   - Complete the registration process\n\n2. Login to npm:\n```bash\nnpm login\n```\n\n3. Build the project:\n```bash\nnpm run build\n```\n\n4. Publish the package:\n```bash\nnpm publish --access public\n```\n\nTo update to a new version:\n1. Update version in package.json\n2. Run `npm publish --access public`\n\n## Available Tools\n\n1. `mcp-excel_createWorkbook`\n   - Creates a new Excel workbook\n   - Parameters:\n     - `filePath`: Full absolute path where the Excel file should be created\n     - `sheetName` (optional): Name of the first sheet\n\n2. `mcp-excel_readCell`\n   - Reads a value from a specific cell\n   - Parameters:\n     - `filePath`: Full absolute path to the Excel file\n     - `sheetName`: Name of the sheet\n     - `cellAddress`: Cell address (e.g., \"A1\")\n\n3. `mcp-excel_writeCell`\n   - Writes a value to a specific cell\n   - Parameters:\n     - `filePath`: Full absolute path to the Excel file\n     - `sheetName`: Name of the sheet\n     - `cellAddress`: Cell address (e.g., \"A1\")\n     - `value`: Value to write\n\n4. `mcp-excel_readFormula`\n   - Reads a formula from a specific cell\n   - Parameters:\n     - `filePath`: Full absolute path to the Excel file\n     - `sheetName`: Name of the sheet\n     - `cellAddress`: Cell address (e.g., \"A1\")\n\n5. `mcp-excel_writeFormula`\n   - Writes a formula to a specific cell\n   - Parameters:\n     - `filePath`: Full absolute path to the Excel file\n     - `sheetName`: Name of the sheet\n     - `cellAddress`: Cell address (e.g., \"A1\")\n     - `formula`: Formula to write (e.g., \"SUM(A1:A10)\")\n\n6. `mcp-excel_readRange`\n   - Reads values from a range of cells\n   - Parameters:\n     - `filePath`: Full absolute path to the Excel file\n     - `sheetName`: Name of the sheet\n     - `range`: Range of cells (e.g., \"A1:C10\")\n\n7. `mcp-excel_writeRange`\n   - Writes values to a range of cells\n   - Parameters:\n     - `filePath`: Full absolute path to the Excel file\n     - `sheetName`: Name of the sheet\n     - `range`: Range of cells (e.g., \"A1:C3\")\n     - `values`: 2D array of values to write\n\n8. `mcp-excel_listSheets`\n   - Lists all sheets in a workbook\n   - Parameters:\n     - `filePath`: Full absolute path to the Excel file\n\n9. `mcp-excel_readFormulaRange`\n   - Reads formulas from a range of cells\n   - Parameters:\n     - `filePath`: Full absolute path to the Excel file\n     - `sheetName`: Name of the sheet\n     - `range`: Range of cells (e.g., \"A1:C10\")\n\n10. `mcp-excel_writeFormulaRange`\n    - Writes formulas to a range of cells\n    - Parameters:\n      - `filePath`: Full absolute path to the Excel file\n      - `sheetName`: Name of the sheet\n      - `range`: Range of cells (e.g., \"A1:C3\")\n      - `formulas`: 2D array of formulas to write\n\n11. `mcp-excel_createSheet`\n    - Creates a new worksheet in an existing workbook\n    - Parameters:\n      - `filePath`: Full absolute path to the Excel file\n      - `sheetName`: Name for the new worksheet\n\n12. `mcp-excel_deleteSheet`\n    - Deletes a worksheet from a workbook\n    - Parameters:\n      - `filePath`: Full absolute path to the Excel file\n      - `sheetName`: Name of the worksheet to delete\n\n## Issues and Bugs\n\nIf you encounter any issues or bugs, please report them at:\nhttps://github.com/anh9th/mcp-excel/issues\n\n## License\n\nISC","readmeFilename":"README.md"}