Tag Archives: MatPlotlib

Using Matplotlib from Excel with pyxll

Posted on 04/11/2021 by dougaj4

The pyxll documentation has many examples of plotting in Excel using Matplotlib and other packages, but I find the multiple options confusing and hard to follow, so this post works through the examples in the Matplotlib Users Guide tutorial. The … Continue reading →

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

Section Properties with MeshPY, including torsion and warping

Posted on 09/12/2017 by dougaj4

I recently discovered robbie van leeuwen’s structural engineering blog, which has an open-source set of Python routines for calculation of section properties, including torsion and warping constants.  The program uses the MeshPY Library for generating the finite element meshes required … Continue reading →

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Strand7, UDFs, VBA, xlwings | Tagged , , , , , , , , | 11 Comments

Using Matplotlib from Excel with xlwings – update

Posted on 07/05/2017 by dougaj4

In February 2016 I posted a spreadsheet with examples of linking to the Python Matplotlib library with xlwings.  Since then updates to xlwings required some changes to the python code, specifically plot.show has been replaced with pictures.add. The spreadsheet has … Continue reading →

Posted in Charts, Charts, Excel, Link to Python, Newton, NumPy and SciPy, VBA | Tagged , , , , , , , | Leave a comment

xlScipy with xlwings

Posted on 20/03/2016 by dougaj4

Following a new release of xlwings, I have updated the xlScipy spreadsheet to work with it, and added a few new features: The Matplotlib routines to plot a function entered as text (previously posted as xlMatPlot.zip) have been incorporated on … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , , , | Leave a comment

Use Matplotlib from Excel with xlwings

Posted on 14/02/2016 by dougaj4

Xlwings is another free and open source package allowing communication between Excel and Python.  It now incorporates ExcelPython, and is included in the Anaconda Python package, so will support my ExcelPython based spreadsheets after installation of xlwings using: conda install … Continue reading →

Posted in Drawing, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, VBA | Tagged , , , , , , | 9 Comments