Category Archives: Computing – general

Importing text files with Python and pyxll

Posted on 02/08/2025 by dougaj4

VBA code to import text files to Excel was presented at Importing text files with VBA – 2 and following posts. We now look at Python code for a user defined function (UDF) for the same task. The code requires Python … Continue reading →

Posted in Computing - general, Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , | Leave a comment

Python Match Case Statement

Posted on 06/06/2025 by dougaj4

The Python match case statement was introduced in Python 3.10. It provides similar functionality to the VBA Select Case statement, but also has additional features. For detailed background with examples see: geekforgeeks – Python Match Case Statement The example below … Continue reading →

Posted in Computing - general, Excel, Link to Python, PyXLL, UDFs | Tagged , , , | Leave a comment

Pandigital sums and Python permutations and combinations

Posted on 13/04/2025 by dougaj4

The New Scientist brain twister from last weeks edition has several problems involving pandigital sums, which are additions that use each of the digits from 0 to 9 exactly once, and with no number within the sum that starts with … Continue reading →

Posted in Arrays, Computing - general, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , , , | Leave a comment

New Links

Posted on 29/03/2025 by dougaj4

My Blogroll (bottom of the right-hand column) is badly in need of updating, but the link below has a list of 60 currently active Excel blogs and websites: 60 Best Excel Blogs and Websites in 2025 Those at the top … Continue reading →

Posted in Bach, Computing - general, Excel, Newton | Tagged , , | Leave a comment

What to do when download links don’t work

Posted on 19/01/2025 by dougaj4

Many of the download links here in older posts use the format http:// rather than https://, and these links now don’t work in Windows. If you find a non-working download link, here is what you can do:

Posted in Computing - general | Tagged , , | Leave a comment