Manual2
XLPack for Python User’s Manual
1. Introduction XLPack for Python (hereinafter abbreviated as XLPack PY) is the add-in program that enables calling Python from Excel VBA. It is similar to Microsoft’s Python in Excel, but it works using a different mechanism. A comparison table is shown below. In summary, “XLPack PY is the add-in for using Python from VBA programs. […]
XLPack for Python 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 […]
XLPack for Matplotlib User’s Manual
1. Introduction XLPack for Matplotlib (hereinafter abbreviated as XLPack MPL) is the program that enable calling Matplotlib from Excel VBA. It maps the major classes and methods of Matplotlib to VBA classes and methods, enabling you to use Matplotlib by entirely using VBA programs. This program is currently under development as the visualization component for […]
XLPack for Matplotlib Reference Manual
XLPack for Matplotlib Reference Manual Overview (open in a separate tab) Details of VBA classes/methods (open in a separate tab) Collection of examples (open in a separate tab)
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 […]
Example program of XLPack for Python and XLPack for Matplotlib: (1) 3D visualization (Laplace equation)
We consider solving the following partial differential equation in the square domain \(x = 0 \sim 1, y = 0 \sim 1\). \[ -d^2u/dx^2 – d^2u/dy^2 = 0 \] The boundary conditions are given as follows. \[ u(x, 0) = 0, u(0, y) = 0, u(x, 1) = x, u(1, y) = y \space (ディリクレ条件) […]
Example program of XLPack for Python and XLPack for Matplotlib: (2) Animation (Simple pendulum)
As shown in the figure below, consider a mass of weight \(m\) suspended by a string of length \(l\) (whose weight is assumed to be negligible) oscillating from side to side. Let \(\theta\) denote the angle measured from the vertical position of the string. This system is called a simple pendulum. This motion can be […]
Example program of XLPack for Python and XLPack for Matplotlib: (3) Animation (Arenstorf orbits)
Consider two bodies with masses \(\mu\) and \(\mu’ (= 1 – \mu)\) undergoing planar orbital motion, and a third body whose mass is negligible compared to the other two, moving in the same plane. The equations of motion are given as follows (reference: E. Hairer et al., “Solving Ordinary Differential Equations I” (1987, 1993), Springer-Verlag). […]
