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 excel
Excel Embraces Python, Opening Doors to New Roles and How PDI Can Help
By PyBites Team on 8 September 2023
In this episode, we delve into the groundbreaking integration of Python within Microsoft Excel and its transformative impact on non-tech professions. 💪📈 Listen here: Or watch here: Discover how this evolution empowers professionals across diverse fields and the dynamic opportunities it presents for career advancement. We also shine a spotlight on the achievements of people… Continue reading Excel Embraces Python, Opening Doors to New Roles and How PDI Can Help
From Excel to Python and succeeding as a Developer by building your portfolio
By PyBites Team on 9 February 2023
Listen here: Or watch here: Welcome back to the Pybites podcast. This week we have an inspirational chat with Juanjo: – How he started his programming journey and what passionates him about this craft. – How he fell in love with Python. – How he overcame tutorial paralysis. – How PDM helped him improve his skills and… Continue reading From Excel to Python and succeeding as a Developer by building your portfolio
Using Python to Check for File Changes in Excel
By Ryan Cheley on 10 April 2020
Finding differences in excel files using Pandas!
Twitter Digest 2018 Week 01
By PyBites Team on 1 January 2018
Every weekend we share a curated list of 15 cool things (mostly Python) that we found / tweeted throughout the week.
Twitter Digest 2017 Week 51
By PyBites Team on 24 December 2017
Every weekend we share a curated list of 15 cool things (mostly Python) that we found / tweeted throughout the week.
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.
Twitter digest 2017 week 06
By PyBites Team on 11 February 2017
On Saturdays we will share a curated list of 15 cool things (mostly Python) we found / tweeted during the week.