Category Archives: Link to Python

Using Python optional arguments from Excel with pyxll

Posted on 14/01/2021 by dougaj4

Python functions allow optional arguments to be specified by allocating a default value to each optional argument. The pyxll add-in allows Python functions called from Excel to work in the same way, so any argument with a default value may … Continue reading →

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

More Open Source FEA Code Links

Posted on 19/12/2020 by dougaj4

The book Nonlinear Finite Element Analysis of Solids and Structures 2nd Edition has an associated python code package called pyFEM, but a search for this code finds several others with the same or similar names: The pyFEM sites associated with the … Continue reading →

Posted in Finite Element Analysis, Frame Analysis, Link to Python, Newton | Tagged , , , | Leave a comment

Open Source FEA Code Links

Posted on 25/10/2020 by dougaj4

There have been many posts here based on code from the book Programming The Finite Element Method, with the Fortran code either translated to VBA, or with VBA links to compiled Fortran Code. I recently discovered: The “Programming the Finite … Continue reading →

Posted in Computing - general, Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to Python | Tagged , , , , | 1 Comment

Using Excel with Python and ctypes

Posted on 05/10/2020 by dougaj4

The Strand7 API provides an interface between the Strand7 Finite Element Analysis program and external software. It works with many different languages, including Python, which uses ctypes to transfer data to and from the API functions. It is essential that … Continue reading →

Posted in Beam Bending, Excel, Link to dll, Link to Python, NumPy and SciPy, PyXLL, Strand7, UDFs | Tagged , , , , , | Leave a comment

Getting near matches from a list with Python

Posted on 19/04/2020 by dougaj4

To return a list of near matches from a long list of strings would be quite difficult in VBA (unless I’m missing something), but in Python it is very simple.  Here is the code for this operation, using pyxll to … Continue reading →

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