Installation Guide

1. Install Python Environment

We recommend using Anaconda to install Python 3.9.12 or Python 3.9.13.

• 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 and complete the setup (default settings are 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 and extract it to a suitable directory.

2. Modify Configuration File:

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

3. Configure Python Path:

   • Open the pyxll.cfg file and locate the executable parameter.
   • Update its value to the path of python.exe in your installation directory. For example:

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

---

3. Load pyxll in Excel

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

---

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.

---