Tag Archives: Link to Python

Scipy linear algebra functions in Excel

Posted on 30/05/2023 by dougaj4

The file pyLinAlgfuncs3.zip has open source Python code allowing the Scipy linear algebra functions to be called from Excel using the pyxll add-in. It also includes all the Python code to perform LU decomposition, as discussed in the previous post., … Continue reading →

Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | 2 Comments

Calling Numpy polynomial functions from Excel

Posted on 31/10/2022 by dougaj4

The Numpy polynomial related function discussed in recent posts can now be downloaded from: py_Numpy.zip The download file includes Python code and a sample spreadsheet. Required installed software is Python, Numba and pyxll to call the code from Excel. Some … Continue reading →

Posted in Curve fitting, Excel, Link to Python, Maths, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , | 1 Comment

Removing Add-ins

Posted on 05/06/2022 by dougaj4

Recently I had problems with an Excel Add-in that was still trying to run, and generating error messages, even after being removed from the add-in list and uninstalled. After much searching and trying suggested methods that didn’t work, I finally … Continue reading →

Posted in Computing - general, Excel, Link to dll, Link to Python, VBA | Tagged , , , , , , | Leave a comment

Python Matrix Functions with ExcelPython – 2

Posted on 28/05/2014 by dougaj4

Following the previous ExcelPython post I have modified the VBA and Python code for improved performance and to simplify the Python coding.  The main change is that where Numpy Arrays are required in the Python code, these are now created … Continue reading →

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