Recent Comments
Category Archives: Computing – general
Importing text files with Python and pyxll
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 Convert string to values, Excel, import text, Numpy, PyXLL, UDFs
Leave a comment
Python Match Case Statement
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 Excel, match case statement, Python, PyXLL
Leave a comment
Pandigital sums and Python permutations and combinations
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 combinations, itertools, Numpy, Pandigital sums, permutations, Python, PyXLL, VBA
Leave a comment
New Links
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 Blog list, Excel links, Feedspot
Leave a comment
What to do when download links don’t work
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:
Newton Excel Bach, not (just) an Excel Blog 