In this podcast episode we talk with Tony Roberts, creator of PyXLL (pronounced “pixel”). Listen here: Also released on our YouTube channel: We dive into the backstory of this Python Excel Add-in, why he built it, features, success stories, the business side of things, and also how it compares to Microsoft’s recently announced Python in… Continue reading Using Python in Excel with PyXLL
Articles on vba
PyBites Module of the Week: Openpyxl – Automate Excel!
By Bob Belderbos on 12 September 2017
You probably remember your first script. I remember the joy of discovering how I could let the machine automate something for me. It still gets me excited everyday. I played a bit with openpyxl yesterday. I used it to hack an Excel game for which I first used a macro. Not particularly useful but a nice exploration of this module.