Python In Office

Read multiple Excel files into Python

We discussed how to read data from a single Excel file. Next we’ll learn how to read multiple Excel files[…]

In the previous post, we touched on how to read an Excel file into Python. Here we’ll attempt to read[…]

Previously, we looked at Excel and Python side by side. Now is the time to dive into the details. The[…]

Magic happens when you use Excel and Python together. Let me put this out first: I love Excel, and I[…]

LAST UPDATED: Nov 08 2021 When I first started this blog, I had one idea in mind – to share[…]

Recently I made a little program to get Outlook calendar meeting data using Python. The program was a result of[…]

Because we are smart and efficient (read: lazy) workers, we want to find flexible and practical ways to run our[…]

In this short tutorial, I will walk you through how to split and merge PDF files using Python. I once[…]

Many people are scared of learning a programming language due to its learning curve. Indeed, even the basics of a[…]

In this tutorial, I will show you how to automate Excel with Python xlwings library. Excel is an awesome software[…]