Tag Archives: PyXLL

Transfer of arrays to/from Python with Pyxll – Part1; Data Types

Posted on 16/03/2014 by dougaj4

This post will look at options for transferring arrays between Excel and Python using Pyxll, including data types, and problems associated with transferring mixed data types.  In the following post I will look at the relative performance of the various … Continue reading →

Posted in Arrays, Excel, Link to Python, VBA | Tagged , , , , | 2 Comments

Global to Local for plates (and three node beams)

Posted on 02/03/2014 by dougaj4

The Glob_to_Loc function (see Converting from global to local coordinates (and vice versa) ) converts forces and deflections of a beam from the global coordinate system to the local system, defined by the longitudinal axis of the beam and a rotation angle … Continue reading →

Posted in Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Strand7, UDFs, VBA | Tagged , , , , , , , | 3 Comments

The angle between two vectors, Python version

Posted on 01/03/2014 by dougaj4

I posted a VBA function to return The angle between two vectors, in 2D or 3D last year, and have just discovered that Python and Numpy are lacking this function.  Since all the suggested code I found in a quick search used: Cos θ … Continue reading →

Posted in Coordinate Geometry, Excel, Link to Python, Maths, Newton, NumPy and SciPy | Tagged , , , | 10 Comments

Converting from global to local coordinates (and vice versa)

Posted on 08/01/2014 by dougaj4

In 3D structural analysis (as well as many other applications) it is necessary to convert section properties, forces, and deflections between coordinate systems defined by individual structural members (local coordinates) and the common coordinate system defining the entire structure (global … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, UDFs, VBA | Tagged , , , , , , , | 22 Comments

Download update – Python downloads

Posted on 08/12/2013 by dougaj4

Download files related to linking to Python from Excel are to be found in: Python matrix functions in Excel, using Pyxll: Download file: http://interactiveds.com.au/software/Matrixpyxll.zip Python for VBA users – 4; Python data types:  The main Python data types, including numpy arrays, with examples … Continue reading →

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