Category Archives: UDFs

Passing variable argument lists from Excel to Python via xlwings

Posted on 08/06/2018 by dougaj4

When calling a Python function it is sometimes necessary to pass a variable number of arguments.  Examples from the xlw_Scipy spreadsheet include: Curve fitting functions, for which the functions to be fitted may have any number of arguments. The Scipy … Continue reading →

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

Returning Arrays From VBA and Python

Posted on 01/06/2018 by dougaj4

Most  of the  user defined functions (UDFs) presented on this blog return a multi-cell array, that must be entered by selecting the output range then pressing Ctrl-shift-enter to display all the results.  This process has several inconveniencies: You need to know … Continue reading →

Posted in Arrays, Excel, Link to Python, UDFs, VBA, xlwings | Tagged , , , , , , , | 1 Comment

More Numpy with Excel and xlwings

Posted on 24/05/2018 by dougaj4

The spreadsheet presented in the last post on sorting also includes links to many other Numpy functions.  The spreadsheet and associated Python file can be downloaded from: xlNumpy.zip The Numpy functions require xlwings and Numpy to be installed, which are included in … Continue reading →

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

Sorting with Python and Numpy

Posted on 19/05/2018 by dougaj4

Following the previous post, lets look at sorting functions in the Numpy library. The spreadsheet xlwNumpy links to a variety of Numpy functions, including the sorting functions described below.  The spreadsheet and associated Python code can be downloaded from: xlNumpy.zip … Continue reading →

Posted in Arrays, Excel, Link to Python, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , | 1 Comment

Sorting with VBA and Python

Posted on 16/05/2018 by dougaj4

This subject was last covered in March 2014.  I have now updated the Python code to work with xlwings, and the new version (including open source VBA and Python code) can be downloaded from: Sortfunc.zip. The previous version, linking to … Continue reading →

Posted in Arrays, Excel, Link to Python, UDFs, VBA, xlwings | Tagged , , , , , | 1 Comment