Tag Archives: PyXLL

Converting from global to local coordinates (and vice versa)

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 , , , , , , , | 21 Comments

Download update – Python downloads

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

Python for VBA users – 5; Using built in numpy functions

Previous Python Post In previous posts in this series I have looked at translating VBA functions to solve quadratic and cubic equations, but the Python numpy library has a polyroots function that will solve polynomials of any degree, and will … Continue reading

Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , , , , , , | 5 Comments

Python for VBA users – 4; Python data types

Previous Python Post The basic range of data types in Python is quite simple, but by the time we have added additional types used in the numpy package, and translation of Excel data types into the Python equivalent the picture … Continue reading

Posted in Arrays, Excel, Link to Python, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , , | 5 Comments

Python for VBA users – 3

In the previous post in this series I looked at translating a routine to solve quadratic equations from VBA to Python.  Using the same process I have also created Python code to solve Cubic equations.  The only added difficulty for the … Continue reading

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

Python for VBA users – 2

This post will look in more detail at translating the VBA Quadratic function (described in Python for VBA users – 1) into a Python function, linked to Excel via PyXll.  For the purposes of this exercise I created a new Python … Continue reading

Posted in Excel, Link to Python, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | 11 Comments

Python for VBA users – 1

Following my recent posts on some preliminary experimentation with linking Excel to Python, this will be the first of a more structured series, mainly as a reminder to myself of lessons learnt on the way, but also I hope of … Continue reading

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