Tag Archives: Excel

Display Matplotlib animations in Excel

Posted on 28/02/2022 by dougaj4

The latest version of pyxll (5.4.0) allows animations generated in Matplotlib to be simply copied to Excel. A spreadsheet with the examples shown below, and the associated Python code can be downloaded from: Animations2.zip The screenshot below shows the simple … Continue reading →

Posted in Animation, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , | 3 Comments

Rounding to significant figures

Posted on 17/02/2022 by dougaj4

Edited 19th Feb 22, following comment from Larry Schuster Excel does not have a function to round numbers to a specified number of significant numbers, and (rather to my surprise) neither does Python. It is not too hard to write … Continue reading →

Posted in Excel, Link to Python, Maths, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , , | 7 Comments

SectionProperties update 3

Posted on 09/02/2022 by dougaj4

The SectionProperties spreadsheets previously posted had limited graphics capabilities due to problems with the plotting routines causing Excel to crash. I have now fixed that problem by updating some Python libraries with pip: installing mkl-service numpy 1.21.2 -> 1.22.1 Pillow … Continue reading →

Posted in Beam Bending, Charts, Charts, Coordinate Geometry, Excel, Finite Element Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL | Tagged , , , , , | 3 Comments

SectionProperties update update

Posted on 26/01/2022 by dougaj4

Since my previous post on the Python SectionProperties program it has been updated to Rel. 2.02, with some major changes: The mesh generation library has been changed from MeshPY to Triangle New functions have been added for: Steel sections Concrete … Continue reading →

Posted in Concrete, Excel, Finite Element Analysis, Link to Python, Newton, PyXLL, Strand7 | Tagged , , , , | 2 Comments

SectionProperties update

Posted on 16/01/2022 by dougaj4

In late 2017 I posted Section Properties with MeshPY, including torsion and warping which looked at an Excel front end for Robbie van Leeuwen’s SectionProperties program, which provides facilities for calculation of section properties of complex shapes, including torsion and warping constants. … Continue reading →

Posted in Charts, Excel, Finite Element Analysis, Link to Python, Newton, Numerical integration, NumPy and SciPy, PyXLL, Strand7 | Tagged , , , , | 1 Comment