Tag Archives: xlwings

Linking Excel to Fortran with ctypes; update

Posted on 27/07/2016 by dougaj4

In the previous post arrays were created in Python and passed to a Fortran dll as ctype pointers.  The data written to these arrays in the Fortran routines was then converted back to Python arrays with statements such as: nodedisp = npc.as_array(nodedisp).  … Continue reading →

Posted in Excel, Finite Element Analysis, Fortran, Link to dll, Link to Python, Newton, NumPy and SciPy, VBA | Tagged , , , , , , , , , , | 3 Comments

Linking Excel to Fortran, via xlwings, Python and ctypes

Posted on 17/07/2016 by dougaj4

Continuing the recent series on using Fortran code published in Programming the Finite Element Method (5th ed. John Wiley & Sons, I.M. Smith, D.V. Griffiths and L. Margetts (2014)), this post looks at linking Excel to Fortran code compiled as … Continue reading →

Posted in Excel, Finite Element Analysis, Fortran, Geotechnical Engineering, Link to dll, Link to Python, Newton, NumPy and SciPy, VBA | Tagged , , , , , , , , , , | 2 Comments

xlwings 0.7.1, dictionaries, and optional arguments

Posted on 08/04/2016 by dougaj4

xlwings 0.7.0 was published at the beginning of March, and introduced direct support for Python dictionaries, which I have used to demonstrate various options for dealing with optional arguments in Excel User Defined Functions (UDFs).  The latest version, 0.7.1, published … Continue reading →

Posted in Curve fitting, Excel, Link to Python, Maths, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , , , | 1 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