Tag Archives: dynamic arrays

Passing 3D arrays to Excel with Python and pyxll

Posted on 18/06/2026 by dougaj4

The previous post looked at options for displaying 1D or 2D arrays in Excel. This post will look at passing 3D arrays from Python to Excel as a cache object, using pyxll, and how to extract selected data from the … Continue reading →

Posted in Arrays, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , | Leave a comment

Dynamic array update and the @ operator

Posted on 11/06/2026 by dougaj4

Many of the user defined functions (UDF’s) presented in this blog return an array rather than a single value. Options for displaying arrays in Excel have changed significantly in recent years and this post looks at the most efficient ways … Continue reading →

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

Excel Dynamic Arrays

Posted on 08/12/2019 by dougaj4

Previews of dynamic arrays in Excel have been available for some time through the “Insider” programme.  They are now being published to general subscribers through Office 365 monthly updates: Further information is given at: Easier array formulas and Dynamic array … Continue reading →

Posted in Arrays, Excel, UDFs | Tagged , , , , , | Leave a comment

Working with dynamic arrays in Excel

Posted on 23/05/2019 by dougaj4

Many of the VBA functions available here return results as arrays, which must be entered by selecting the desired output range, then  pressing Ctrl-Shift-Enter (CSE).  This can be inconvenient (or at least untidy) when the size of the output array varies.  … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , | Leave a comment

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