Tag Archives: UDF

Range tips

Posted on 17/11/2014 by dougaj4

A couple of tips on Excel ranges, coming from questions on the Eng-Tips Forum: 1. How to rotate a range: The Transpose function (or option in the Paste-Special dialog box) will swap the rows and columns of a range, but … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 6 Comments

ExcelPython2, Alglib and Spline-Matrix Rel 2.03

Posted on 06/10/2014 by dougaj4

Following a comment here: ExcelPython2, Alglib and Spline-Matrix update I have updated the VBA and Python code, and added a missing Python module to the download zip file.  See the earlier post for details of installation and use, or download the revised files … Continue reading →

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

Binary functions, combining text, and finding unique columns

Posted on 30/09/2014 by dougaj4

I recently had an e-mail request asking for a method of finding unique columns in an Excel table consisting of either blank cells or an entry of 1.  An easy way to do this would be to convert the columns to … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 1 Comment

Run Fortran from Excel with Python and F2Py

Posted on 15/09/2014 by dougaj4

I have previously posted on the use of the Silverfrost Fortran compiler with Excel (e.g. Linking Excel to Fortran).  More recently I have been concentrating on accessing high performance compiled routines via Python and the Python maths and science libraries … Continue reading →

Posted in Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to Python, Maths, Newton | Tagged , , , , , , , , | 6 Comments

ExcelPython2, Alglib and Spline-Matrix update

Posted on 12/09/2014 by dougaj4

The ExcelPython add-in, offering easy access to Python code from Excel VBA, has had a major update to Release 2.  The new version provides new features and simpler installation, but has some incompatibilities with code written for the previous  version, so the … Continue reading →

Posted in AlgLib, Excel, Link to Python, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , | 4 Comments