Recent Comments
Brad Clarke on Section properties for groups… 
dougaj4 on Section properties for groups… Brad Clarke on Section properties for groups… Brad Clarke on Section properties for groups… dougaj4 on Dots and Crosses 
Stephen Cooke on Dots and Crosses dougaj4 on Two songs = 2/3 Wikipedia 
Tom Barsh on Two songs = 2/3 Wikipedia 
Jon Peltier on Two songs = 2/3 Wikipedia Returning Arrays Fro… on More Numpy with Excel and… More Numpy with Exce… on Using Array Functions and… More Numpy with Exce… on Sorting with Python and N… Office Insiders and… on JavaScript UDFs in Excel Sorting with Python… on Sorting with VBA and Pyth… Sorting with VBA and… on Dynamic sorting with Excel, VB…
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 dictionaries, Excel, ParamArray, Passing arrays, Passing named arguments, Python, UDFs, VBA, xlwings
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
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 Excel, Excel for You, Excel Matters, links, My Spreadsheet Lab
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 dynamic arrays, Excel, Python, resizing array functions, UDFs, using array functions, VBA, xlwings
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 Anaconda, Excel, math functions, Numerical ranges, Numpy, Polynomial functions, Python, Trig functions, UDF, VBA, xlwings
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
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 Excel, Linked Data Types, Office Insiders, Power Pivot
Leave a comment
