The ExcelPython add-in, offering easy access to Python code from Excel VBA, has had a major update to Release 2. The new version provides new features and simpler installation, but has some incompatibilities with code written for the previous version, so the Excel Spline-Matrix spreadsheet has been updated to work with the new release.
Those wishing to generate their own ExcelPython applications can download the latest release from the ExcelPython github site. If you just want to use the spline-matrix spreadsheet all the necessary ExcelPython files are included in the download; see below for installation details.
As well as the included ExcelPython files the spreadsheet requires:
- Python version 2.6 or later, or any version 3, with PYWin32 installed. The Alglib code does not require Numpy, but the Python interface code does, so this must be installed. I can recommend the Anaconda package, which is comprehensive with simple installation.
- The Alglib Python package, which can be downloaded here, with installation instructions here. The Python for Windows package comes with full compiled code, and has very simple installation (but install Python first).
- After installing Python then Alglib, simply copy the contents of the Spline-Matrix zip file to any convenient folder.
Following this procedure the Spline-Matrix spreadsheet should work with 32 bit Excel and Python with no changes of settings, other than enabling macros at start-up, if your security settings require this. The 64 bit version of Excel Python is still under development, and I have not checked the spreadsheet with 64 bit Excel. Any problems, please let me know. Some examples of the included functions are shown below. For a full list of the available functions, see the index sheet.