XLPack for Matplotlib Installation Manual

1. System requirements

– Windows 11 or Windows 10 (22H2 64 bit version)
– Excel for Office 365, Excel 2024 or Excel 2021 (64 bit version)
– Python 3.13 or later (64 bit version)

Before installing this software, update your software to the latest versions.

2. Installing Python

First, make sure that Python 3.13 or later is installed and running properly. When installing Python, be sure to check the option “Add python.exe to PATH.”

In addition, NumPy and Matplotlib must be installed in Python. Furthermore, SciPy is also required for Spy_Csc and Spy_Csr. To save animations as video files, ffmpeg or similar software is required.

3. Installing XLPack for Matplotlib

Double-click the installer to launch it and follow the on-screen instructions. The installation is performed on a per-machine basis.

4. Setting up your Excel

After installation of the software, you need to set up the Excel.

4.1 References setting

Open Excel file and run Visual Basic editor by clicking “Visual Basic” button in “Developer” tab. Select “Tools” -> “References” and check “XLPack_PY”. The reference settings apply only to the Excel file in which they are configured.

Note – If you cannot find the “Developer” tab, select “File” tab -> “Options” -> “Customize Ribbon” and check “Developer”.

Note – You need to configure the reference settings for each Excel file that uses XLPack for Matplotlib. Since the reference settings are saved within the Excel file, you do not need to configure them again the next time you open it.

5. Uninstalling XLPack for Matplotlib

To uninstall XLPack for Matplotlib, use “Settings” -> “Apps” > “Apps & features”. Choose “XLPack for Matplotlib” and click “Uninstall”.