### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- The angle between two vectors, Python version
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fitting high order polynomials
- Frame Analysis with Excel - 4, 2D frame analysis
- Using LINEST for non-linear curve fitting

### Recent Comments

OliviaHoros on Commenting a block of code in… Column buckling unde… on Using Frame4Buckle with the Al… Column buckling unde… on Buckling of columns with varyi… dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update DonB on Biaxial bending update Perko on Installing Adobe Reader non-DC… Python Traps | Newto… on The meaning of = in Pytho… dougaj4 on P-Y Curve function Zhitong Zhang on P-Y Curve function Matt Cornell on Newton’s Cradle Clive James and Pete… on The Barrow Poets dougaj4 on Excel to Alglib via xlwin…

# Tag Archives: PyXLL

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

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 Data types, Excel, Python, PyXLL, VBA
2 Comments

## Global to Local for plates (and three node beams)

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 Excel, Glob_to_Loc3, IP2.xls, Loc_to_Glob3, Python, PyXLL, UDF, VBA
3 Comments

## The angle between two vectors, Python version

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 angle between two vectors, Numpy, Python, PyXLL
10 Comments

## 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 axis rotation, Excel, global axes, local axes, Python, PyXLL, UDF, VBA
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

## 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 complex numbers, Cubic, Excel, high order polynomials, Jenkins-Traub Method, Polynomial, Python, PyXLL, Quadratic, Quartic, UDF, VBA
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 complex numbers, Excel, numpy arrays, Python, Python lists, PyXLL, UDF, VBA
5 Comments