Tag Archives: Python

Numpy and Scipy for Excel

Posted on 14/12/2014 by dougaj4

The Python Numpy and Scipy libraries contain a huge number of maths and science related functions.  Most of these are not directly available from Excel, but using the free ExcelPython package it is fairly easy to make the link, vastly increasing … Continue reading →

Posted in Excel, Link to Python, Maths, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | 11 Comments

ExcelPython2, Alglib and Spline-Matrix Rel 2.03

Posted on 06/10/2014 by dougaj4

Following a comment here: ExcelPython2, Alglib and Spline-Matrix update I have updated the VBA and Python code, and added a missing Python module to the download zip file.  See the earlier post for details of installation and use, or download the revised files … Continue reading →

Posted in AlgLib, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | Leave a comment

Run Fortran from Excel with Python and F2Py

Posted on 15/09/2014 by dougaj4

I have previously posted on the use of the Silverfrost Fortran compiler with Excel (e.g. Linking Excel to Fortran).  More recently I have been concentrating on accessing high performance compiled routines via Python and the Python maths and science libraries … Continue reading →

Posted in Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to Python, Maths, Newton | Tagged , , , , , , , , | 6 Comments

ExcelPython2, Alglib and Spline-Matrix update

Posted on 12/09/2014 by dougaj4

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 … Continue reading →

Posted in AlgLib, Excel, Link to Python, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , | 4 Comments

Alglib/Python spline functions update

Posted on 02/08/2014 by dougaj4

The Excel Spline-Matrix spreadsheet has now been updated with several new spline interpolation functions.  See Alglib/Python linear and non-linear fitting functions for links to download and install the necessary Excel-Python and Alglib files.  Also required is Python version 2.7 or 2.6. The … Continue reading →

Posted in AlgLib, Arrays, Excel, Link to Python, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , | 2 Comments