Tag Archives: Excel

Transferring different data types to/from Python with pyxll

Posted on 12/05/2026 by dougaj4

When a user defined function (UDF) is created in Excel with Python and pyxll the data type of each argument can be specified, either in the @xl_func decorator, or with a separate @xl_arg decorator for each argument. I prefer the … Continue reading →

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

Scipy-statistics with distributions

Posted on 01/05/2026 by dougaj4

The Scipy statistics functions last presented here have now been updated with the addition of links to the numerous distribution functions. The py_Stats spreadsheet, with associated Python code in PythonStatsFuncs3.py and pyScipy3.py, and also minor updates to the pyNumpy.py code, … Continue reading →

Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, Python Pandas, PyXLL, UDFs | Tagged , , , , , , , , , | Leave a comment

Dealing with annoying Excel defaults

Posted on 27/04/2026 by dougaj4

Mynda Tracey’s MyonlineTrainingHub has a recent post on how to change 15 Excel default settings at: Excel Settings You Need to Change Raise your hand if Excel’s default settings have ever driven you just a little bit crazy. Maybe your … Continue reading →

Posted in Excel | Tagged , , | Leave a comment

… and finally py_xlCBA 0.6 with trapezoidal loads

Posted on 11/04/2026 by dougaj4

The latest version of the Python continuous beam analysis program pyCBA is 0.7, allowing for specification of trapezoidal distributed loads, and this is now available with pip. I have updated the py-xlCBA spreadsheet and associated code to use the latest … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Link to Python, Newton, PyXLL, Strand7, UDFs | Tagged , , , , , , , , , , , , | Leave a comment

… and then py_xlCBA 0.5

Posted on 05/04/2026 by dougaj4

Following the previous post, more detailed checking found that the code was returning an error for beams with a support at X = 0. This has now been fixed, and the revised code and spreadsheets can be downloaded from: py_xlCBA.zip … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7, UDFs | Tagged , , , , , , , , , , | Leave a comment