Author Archives: dougaj4

Passing variable argument lists from Excel to Python via xlwings

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 , , , , , , , , | Leave a comment

Two songs = 2/3 Wikipedia

It is said that a picture is worth a 1000 words. On the same basis, a poem is worth 1000 pictures, and a song is worth 1000 poems. So two songs are worth 2 billion words, which is about 2/3 … Continue reading

Posted in Bach | Tagged , , | 3 Comments

New Links – 2018

Some new links to active Excel related blogs: David Hagar has been active in the Excel community for many years, and has published the Excel For You blog since 2013.  I was led to it by a recent post on a UDF … Continue reading

Posted in Computing - general, Excel | Tagged , , , , | Leave a comment

Returning Arrays From VBA and Python

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 , , , , , , , | Leave a comment

More Numpy with Excel and xlwings

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 , , , , , , , , , , | 1 Comment

More Lowlands

Sometimes YouTube suggestions are hopeless, and sometimes they are spot on.  Here is one of the latter: It seems that Ali Darragh is yet to be deemed Wiki-worthy, but there is a good article about her here. That link led … Continue reading

Posted in Bach | Tagged , , , | Leave a comment

Office Insiders and Power Pivot

I recently discovered another benefit of the Office Insiders program through the ExcelUnplugged blog, which has a feature on the new linked data types in Excel.  More on those another day, but in addition to JavaScript UDFs, the added feature that I found to … Continue reading

Posted in Computing - general, Excel, Javascript | Tagged , , , | Leave a comment