Tag Archives: Python

Python for VBA users – 1

Posted on 24/09/2013 by dougaj4

Following my recent posts on some preliminary experimentation with linking Excel to Python, this will be the first of a more structured series, mainly as a reminder to myself of lessons learnt on the way, but also I hope of … Continue reading →

Posted in Excel, Link to Python, UDFs, VBA | Tagged , , , , , | 2 Comments

Sorting with Python

Posted on 19/09/2013 by dougaj4

A previous post provided a VBA Sort function that could be used as a User Defined Function (UDF) to provide a sorted list on the spreadsheet, or called from another VBA routine to sort an array. I have just written a … Continue reading →

Posted in Arrays, Excel, Link to Python, UDFs | Tagged , , , , , | 5 Comments

Installing Python, Scipy and Pyxll

Posted on 09/09/2013 by dougaj4

I have recently been experimenting with Pyxll, which after a few initial hiccoughs is proving to be an easy and efficient way to connect Excel to Python based scientific and maths applications, such as linear algebra routines and ODE solvers.  … Continue reading →

Posted in Excel, Link to dll, Link to Python | Tagged , , , , | 15 Comments

More about not being different

Posted on 29/04/2010 by dougaj4

Last year I posted a link to a puzzle at Tanya Khovanova’s Math Blog.  I just came across a follow up to that puzzle: The Odder One Out where she discusses the responses.  Which by some devious path reminded me … Continue reading →

Posted in Bach | Tagged , | Leave a comment