MCP Excel Installation Guide

1. Install Python Environment

We recommend installing Python 3.9.12 or 3.9.13 using Anaconda.

• Option 1: Install Anaconda:

  • Anaconda Official Download
  • Anaconda Domestic Mirror

• Installation Steps:

  1. Run the downloaded Anaconda3-2022.05-Windows-x86_64.exe.
  2. Follow the installation wizard, keeping default settings recommended.

• Option 2: Use Python Portable Package:

  • Download link: Python Portable Package python.zip

• Installation Steps:

  1. Simply extract python.zip to use.

---

2. Download and Configure mcp_excel

1. Download mcp_excel:
   • Obtain the mcp_excel_xxx.zip file (Download Link) and extract it to a suitable directory.

Note: The installation package already includes Excel and Python programming support.

2. Modify Configuration File:

   • Navigate to the \lib\X64\ folder in the extracted directory.
   • Rename pyxll.cfg.txt to pyxll.cfg.

3. Configure Python Path:

   • Open the pyxll.cfg file and locate the executable parameter.
   • Modify its value to point to your python.exe path. For example:

     executable = C:\ProgramData\Anaconda3\python.exe  
     or  
     executable = C:\ProgramData\python\python.exe

---

3. Load pyxll in Excel

1. Open Excel.
2. Click File → Options → Add-ins.
3. At the bottom, select Excel Add-ins from the "Manage" dropdown and click Go.
4. In the new window, click Browse and locate the pyxll.xll file in your extracted mcp_excel directory:
   • For 32-bit Excel, choose the Win32 version.
   • For 64-bit Excel, choose the X64 version.
5. Click OK to complete the loading.

---

Important Notes

• Ensure the installed Anaconda version matches your system architecture (32-bit or 64-bit).
• If loading fails, verify that the executable path in pyxll.cfg is correct.

---